Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I have the following measure
For Today (Plan) = IF([MES_Passed]<[MES_Cumm Script Execution Plan Until Today],
[MES_Cumm Script Execution Plan Until Today]-[MES_Passed],
[MES_Cumm Script Execution Plan Until Today]-[MES_Cumm Script Execution Plan Until Yesterday])
Power BI Output :https://drive.google.com/open?id=1juAYttZmtry0bziDveNw4_WsTp_JoreS
But the desired output we are looking for is
https://drive.google.com/open?id=1NFkWIuFC89PWyAaaPmcJqOmAyAqQEuTV
I have tried with HASONEVALUE while the row values are correct but the row subtotals/grand totals are not populated with the sum of "For Today (Plan)" column in Power BI.
MES_Cumm Script Execution Plan For Today = IF(OR(HASONEVALUE('Scenario Script Summary'[Testing team]),HASONEVALUE('Scenario Script Summary'[Scenario owning team])),
IF([MES_Passed]<[MES_Cumm Script Execution Plan Until Today],
[MES_Cumm Script Execution Plan Until Today]-[MES_Passed],
[MES_Cumm Script Execution Plan Until Today]-[MES_Cumm Script Execution Plan Until Yesterday])).
Solved! Go to Solution.
This is because PowerBI doesn't SUM the values of the measures in subtotals for matrices. Instead, it recalculates the measure with the entire subgroup as the dataset. From the images you provided, it looks like subtotals/totals are calculating as expected in both. If you're looking to enter 0 where you get a blank result, add zero to any mathematical expression to guarantee a value. I'm not sure how your data is structured, so it's hard for me to try and help you with DAX code directly.
You can read about my adventures trying to fight this behavior, and a description of how to calculate the subtotal differently than the values within the matrix here: https://community.powerbi.com/t5/Desktop/Only-Total-Select-Values-in-a-Matrix-amp-Formatting-Help/m-...
This is because PowerBI doesn't SUM the values of the measures in subtotals for matrices. Instead, it recalculates the measure with the entire subgroup as the dataset. From the images you provided, it looks like subtotals/totals are calculating as expected in both. If you're looking to enter 0 where you get a blank result, add zero to any mathematical expression to guarantee a value. I'm not sure how your data is structured, so it's hard for me to try and help you with DAX code directly.
You can read about my adventures trying to fight this behavior, and a description of how to calculate the subtotal differently than the values within the matrix here: https://community.powerbi.com/t5/Desktop/Only-Total-Select-Values-in-a-Matrix-amp-Formatting-Help/m-...
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |