Forum Discussion
DAX Measure Total Wrong
EricShahi 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
Hi Greg,
I read thorugh your documnets around the issue on the measures totals, I tried to used your techinique but still no luck.
Test USDRR =
VAR gggest =
SUMX (
'Pol (measures) (measures)',
[Gross Written Premium Our Share]
)
VAR AggPremum =
SUMX(
ADDCOLUMNS (
SUMMARIZE (
'Pol (measures)',
'Pol (measures)'[Reporting Currency],
'Pol (measures)'[Policy ID]
),
"@ToUSDRates",
IF (
ISBLANK (
LOOKUPVALUE (
'Exchange Rate'[ExchangeRate Factor],
'Exchange Rate'[Currency From], 'Pol (measures)'[Reporting Currency],
'Exchange Rate'[Currency To], "USD"
)
),
1,
LOOKUPVALUE (
'Exchange Rate'[ExchangeRate Factor],
'Exchange Rate'[Currency From], 'Pol (measures)'[Reporting Currency],
'Exchange Rate'[Currency To], "USD"
)
),
"@AmountinSett", gggest
),
IF (
HASONEFILTER ( 'Pol (measures)' [Policy ID] ),
[@AmountinSett] * [@ToUSDRates],
SUMX (
FILTER (
'Pol (measures)',
[@AmountinSett] > 10000000
),
[@AmountinSett] * [@ToUSDRates]
)
)
)
RETURN
AggPremum