Download Start File file: https://excelisfun.net/files/EMT1395Start.xlsx
Download Finished Excel File: https://excelisfun.net/files/EMT1395Finished.xlsx
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.

1. (00:04) Download Files
2. (00:14) Introduction
3. (01:50) look at our source data tables and relationships in the Excel Power Pivot Data Model
4. (03:52) Brief Discussion about Relations between table and how they help DAX Formulas and the Data Model to calculate quickly on big data.
5. (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.
6. (10:00) % of Grand Total: using ALL, CALCULATE and DIVIDE DAX Functions.
7. (17:20) % of Grand Total Set by Slicer: using ALLSELECTED, CALCULATE and DIVIDE DAX Functions.
8. (20:32) % Column Total: using ALLSELECTED, CALCULATE, VALUES and DIVIDE DAX Functions.
9. (26:22) % Parent Total using: ALLSELECTED, CALCULATE, VALUES, DIVIDE, IF, ISFILTERED and BLANK DAX Functions.
10. (33:28) Summary

Reference Video:
Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total
Excel Magic Trick 1393: PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total
Excel Magic Trick 1395: DAX Formulas for % Grand Total, % Column Total, % Parent Total



Search Phrase Keys: How to create Show Values As Calculations in Excel Power Pivot. How to create Show Values As Calculations in DAX. How to create Show Values As Calculations in Power BI Desktop. How to create Show Values As % Column Total Calculations in Excel Power Pivot. How to create Show Values As % Column Total Calculations in Power BI Desktop. How to create Show Values As % Column Total Calculations with DAX Expression. How to create Show Values As % Parent Total Calculations in Excel Power Pivot. How to create Show Values As % Parent Total Calculations in Power BI Desktop. How to create Show Values As % Parent Total Calculations with DAX Expression. How to create Show Values As % Grand Total Calculations in Excel Power Pivot. How to create Show Values As % Grand Total Calculations in Power BI Desktop. How to create Show Values As % Grand Total Calculations with DAX Expression.