[Free ebook Amazon]The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) by Alberto Ferrari & Marco Russo

DOWNLOAD PDF
DOWNLOAD AZW3

Author:Alberto Ferrari & Marco Russo [Ferrari, Alberto]
Language: eng
Format: azw3 + pdf
Publisher: Pearson Education
Published: 2015-10-14T04:00:00+00:00

FIGURE 10-1 This is the table we will use to understand exactly how ALLSELECTED works.

Based on this table, you can easily create a pivot table with a slicer that selects only two rows and the Sum of Val in the value area, which you can see in Figure 10-2.

FIGURE 10-2 Here you can see a very simple pivot table based on our one table model.

There is nothing special here. We filter two values, and all the numbers are correct. Now, to introduce ALLSELECTED, you define a new measure, using this code:

[SumAllSelected] :=

CALCULATE (

SUM ( Table[Val] ),

ALLSELECTED ( )

#evba #etipfree #eama #kingexcel

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1