Forum Discussion
sum problem with dax
Hello,
I have an example on https://drive.google.com/drive/u/0/my-drive , i don't know hot to the same value that i get a sum like in peacture.
Please help me.
Thx
Lea
4 Replies
LeaRupnik 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/547907And I think you specifically want something like MM3TR&R:
Hi, LeaRupnik
It’s my pleasure to answer for you.
According to your description,I think it should be that your measure doesn't apply to the hierarchy and needs to be modified.Can you share some sample data and your measure or your desired result? So we can help you soon.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-janeyg-msft ,
there is example
usp=sharinghttps://drive.google.com/file/d/1Jy0l-WGouAHszo3eCFNzERGOwIM9_p37/view?usp=sharing
Thx
Lea
Hi, LeaRupnik
I checked your file, but I was confused.
Can you tell me the calculation logic and the correct result I want? Otherwise it will be difficult for me to stand on your side.
Best Regards
Janey Guo
