topic Re: How to correct Matrix totals (some months has blank values) in DAX Commands and Tips

How to correct Matrix totals (some months has blank values)

learnerdax — Tue, 25 Apr 2023 00:06:25 GMT

Hi Experts,

Im trying to correct Totals in Matrix ,Please help me to correct totals.Please check below Snip,im try to do YTD Sales/YTD Qty here im getting 13.33 , But i need 30 Total by Country.I tried below Dax,but its givig blanks for Blank months,it should add up to YTD(Ex Jan -10, Feb -blank,March -30,Then if i select Feb need to get 10 instaed of blank).I can use only Measue(Data set is live)
IF(Hasonevalue(Table(Country),[YTD Sale/YTD QTY Measure],SUMX(Values(Table(Country),[YTD Sale/YTD Qty Measure))

tamerj1 Could you please check

Re: How to correct Matrix totals (some months has blank values)

FreemanZ — Mon, 24 Apr 2023 21:49:31 GMT

hi learnerdax

how is [YTD Sale/YTD QTY Measure] defined?

Re: How to correct Matrix totals (some months has blank values)

Ajendra — Mon, 24 Apr 2023 21:49:52 GMT

Hello,

I hope you are doing well!

Generally YTD Dax we uses with dates.

In my case it is showing correct, have a look here pls!

Thanks!!

Re: How to correct Matrix totals (some months has blank values)

learnerdax — Mon, 24 Apr 2023 23:58:18 GMT

FreemanZ , Thanks for checking
YTD Sale = TOTALYTD(SUM(Sales),Calendar Date Column)
YTD Qty = TOTALYTD(SUM(Qty),Calendar Date Column)
i tried with sumx in YTD Sales and YTD Qty ,still im facing issue with totals.Please check

Re: How to correct Matrix totals (some months has blank values)

learnerdax — Tue, 25 Apr 2023 00:01:03 GMT

Hi Ajendra ,Thank you for answering but Im not facing any issue with YTD sales Totals and YTD Qty totals, if i divide YTD Sales/YTD Qty my totals are not corrrect ,because of row context in totals.

Re: How to correct Matrix totals (some months has blank values)

tamerj1 — Tue, 25 Apr 2023 10:36:07 GMT

Greg_Deckler

Re: How to correct Matrix totals (some months has blank values)

Greg_Deckler — Tue, 25 Apr 2023 17:28:41 GMT

learnerdax First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8