topic Re: sum problem with dax in Report Server

sum problem with dax

LeaRupnik — Fri, 08 Jan 2021 10:02:51 GMT

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

Re: sum problem with dax

Greg_Deckler — Fri, 08 Jan 2021 11:19:25 GMT

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-Roll/m-p/411443#M150

Re: sum problem with dax

v-janeyg-msft — Mon, 11 Jan 2021 05:47:22 GMT

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.

Re: sum problem with dax

LeaRupnik — Mon, 11 Jan 2021 06:42:46 GMT

Hello v-janeyg-msft ,

there is example

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

Thx

Lea

Re: sum problem with dax

v-janeyg-msft — Mon, 11 Jan 2021 09:06:05 GMT

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