Forum Discussion
Switch function not calculating total
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
I will delve into this and see if I can come up with a formula that works based on your post. Any idea why it is showing zero for this particular column? I double checked the totals for my other measures and they seem to be correct.
The total line evaluates in the context of ALL rows in the table. So, it is likely that one of your criteria for the SWITCH to not return 0 is not true in the context of ALL and thus you get 0 as specified in the formula.
Hi Anonymous,
Did you solve it? It could be like this.
Daily Non-Compliant = SWITCH ( TRUE (), 'Prod Ops'[Prod Shipments] = 0 && [Test Shipments] = 0, ROUNDUP ( SUM ( 'Ops Plan'[Weekly Planned Frequency] ) / 265, 0 ), NOT HASONEVALUE ( 'Prod Ops'[Prod Shipments] ) && NOT HASONEVALUE ( [Test Shipments] ), SUM ( 'Ops Plan'[Weekly Planned Frequency] ), 0 )
Best Regards,
Dalev-jiascu-msft, I'm not sure exactly how the formula is supposed to work, but you can see below that there are errors in the format.
Hi Anonymous,
It seems the 'Prod Ops'[Prod Shipments] is a measure. In short, the newly added step judges the context of the Total and then assign the proper value to the Total before it takes the default value 0.
What should the 'Prod Ops'[Prod Shipments] be for the Total? Then it could be like below.
'Prod Ops'[Prod Shipments] <> 0, SUM ( 'Ops Plan'[Weekly Planned Frequency] ),
Best Regards,
Dale
