Forum Discussion
How to Fix Measure to Get Accurate Subtotal
How can I get the measure below to give me a correct subtotal? The individual values are correct, however, I'd like to be able to remove the PDN field and see a total of $189,200.
Measure Test =
var _ROE = (SUM(f_BFS_DEALER_PROF[CONS_NET_INCOME]) / SUM(f_BFS_DEALER_PROF[CONS_ROE_DENOM])) * .09 / .76
var _PF1 = SUM('f_BFS_DEALER_PROF'[RETAIL_NAALR]) / SUM ('f_BFS_DEALER_PROF'[RETAIL_SSNAR])
var _PF2 = SUM('f_BFS_DEALER_PROF'[RETAIL_NAALR]) / SUM ('f_BFS_DEALER_PROF'[RETAIL_SSNAR])
var _PFLoss = SUM(f_PROFORMA_LOSS[LTD_ACTUAL_LOSS]) / SUM (f_PROFORMA_LOSS[PRICED_NAALR])
var _SSNAR = SUM(f_BFS_DEALER_PROF[CONS_SSNAR])
RETURN _SSNAR * ( (_ROE + ((_PF2 * _PFLoss) - _PF1)) * 0.76 / 0.09 )
1 Reply
- Greg_Deckler
Community Champion
Alfista1997 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
