See how to simulate the Standard PivotTable Show Values As calculations of % of Grand Total, % of Column Total and % of Parent Total. See the DAX Functions: CALCULATE, ALL, ALLSELECTED, VALUES, DIVIDE, BLANK, ISFILTERED, and IF. The DAX Measures demonstrated will work in Excel Power Pivot or Power BI Data Models.
(00:04) Download Files
(01:50) look at our source data tables and relationships in the Excel Power Pivot Data Model
(03:52) Brief Discussion about Relations between table and how they help DAX Formulas and the Data Model to calculate quickly on big data.
(05:54) Look at the DAX Calculated Column and DAX Measure that are already in the Data Model and build a PivotTable to demonstrate “Filter Context” and look at how it will influence the DAX that we will create.
(10:00) % of Grand Total: using ALL, CALCULATE and DIVIDE DAX Functions.
(17:20) % of Grand Total Set by Slicer: using ALLSELECTED, CALCULATE and DIVIDE DAX Functions.
(20:32) % Column Total: using ALLSELECTED, CALCULATE, VALUES and DIVIDE DAX Functions.
(26:22) % Parent Total using: ALLSELECTED, CALCULATE, VALUES, DIVIDE, IF, ISFILTERED and BLANK DAX Functions.