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

Author:Alberto Ferrari & Marco Russo [Ferrari, Alberto]
Language: eng
Format: azw3
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 ( )

)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.