Dax Functions
1) All() Function: Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table. This function is not used by itself, but serves as an intermediate function that can be used to change the set of results over which some other calculation is performed. a) It is used to ignore filters from one or more table. b) This function is not used by itself, but serves as an intermediate function. Ex-1: CALCULATE([Sales], ALL(DimCustomer)) //DimCustomer is a "Dimension Table" Ex-2: CALCULATE([Sales], ALL(DimCustomer), ALL(DimProduct)) //DimCustomer & DimProduct are "Dimension Table" ...