Forum Discussion
Helper IWrong Total with DAX Measure
Solution Specialistdb1Intermtn It's because the total doesn't sum the individual values but applies the same logic as your measure to the entire context you're in.
I'm just curious why you have such a complex logic since the measure is not a running total.
You should be just fine with a proper calendar table and a simple SUM measure.
Then you'd just put the weeknum field and the measure in your visual and you should be fine.
Helper Isimple SUM measure doesn't work for me in this case because here I am calculating the YTD values for each branch but there is a condition that YTD should be calculated from the same week since when the data is available for that branch from last year.
If branch A has data from week 3 of 2019, my measure calculates YTD for that branch for 2020 from week 3 and not from week 1.
Any way I can get the correct total here with my measure?
- Greg_Deckler
Community Champion
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/547907Can't be more specific than that without sample data to test with. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
