Forum Discussion
URGENT Help needed!! Measure reference is not working
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, you might find this handy:
Time Intelligence the Hard Way
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Hi Greg_Deckler -
Thanks for the awesome solution.
I have created a measure (TotalDCF) as per your Quick Measure, Measure Totals, The Final Word article. But it still shows the same wrong total. I've added the version here. Will appreciate if you can share your idea.
Thanks
https://drive.google.com/file/d/1eETkJ2dM2B0txsRme9mPswluDcxVx-KW/view?usp=sharing
Will appreciate if you anyone can have a look on my file. I have created a measure (TotalDCF) as per your Quick Measure, Measure Totals, The Final Word article. But it still shows the same wrong total. I've added the version here.
Thanks in advance
https://drive.google.com/file/d/1eETkJ2dM2B0txsRme9mPswluDcxVx-KW/view?usp=sharing
Pushing it forward again..
Appreciate your help.