Forum Discussion
Solved
Measure Grand total not matching
Hello team, i have created a measure where the grand total should be £96656.89 but im getting a different grand total. This is my measure : GBPConverstion = var convertgbp = CALCULATE( SUM...
Please try this to get the correct total. It references your existing measure. Use it in place of your current measure in the visual.
New GBPConversion = SUMX(VALUES('Date'[Month]), [GBPConversion])
Regards,
Pat
Please try this to get the correct total. It references your existing measure. Use it in place of your current measure in the visual.
New GBPConversion = SUMX(VALUES('Date'[Month]), [GBPConversion])
Regards,
Pat
Thank you for this. That did work.
However i really didnt want to call it to another measure. Is there a way, where i could have it all in one measure?