sum problem with dax

[LeaRupnik]

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

[v-janeyg-msft]

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.

[LeaRupnik]

Hello @v-janeyg-msft , 

there is example

usp=sharinghttps://drive.google.com/file/d/1Jy0l-WGouAHszo3eCFNzERGOwIM9_p37/view?usp=sharing

Thx

Lea 

[v-janeyg-msft]

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

[Greg_Deckler]

@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/547907

And I think you specifically want something like MM3TR&R:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...