-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
DAX includes two functions that allow us to remove filters within a DAX calculation. These functions are ALL and ALLSELECTED. As preparation for exploring these functions, perform the following steps:
These instructions continue from the previous section, Looking up Values. If you have not completed that section, simply download and open LookingUpValues.pbix from the Chapter 2 folder of the following GitHub repository: https://github.com/gdeckler/DAX-For-Humans/tree/main/book
Select and delete all visuals on the page except the Table visualization that includes the Date column. You can do this by selecting each visual with your mouse and then pressing the Del (delete) key.
With this preparation complete, create the following measure:
Max Total Cost All Rows =VAR __Table = ALL( 'Table' )VAR __Result = MAXX( __Table, 'Table'[Total Cost] )RETURN__Result
Place this measure into the remaining Table visualization...