topic Re: Matrix and subtotals once again in DAX Commands and Tips

Matrix and subtotals once again

celen — Tue, 30 Jan 2024 19:40:53 GMT

Hi,

I am again struggeling with matrix visual and subtotal.

In my inventory table I get the number of days since the product was last sold. In the matrix to the left, I am adding one day for each day going forward.

In the matrix to the right I only want to show the value of the products when the number of days exceeds 365, as it does for the last product on the list (81). The problem is that it calculates the number of days on the subtotal level "In Product" as well, which gives the wrong total value (5277). How should I correct my measure so I get the correct total 81?

Br,

Chris

Re: Matrix and subtotals once again

Greg_Deckler — Tue, 30 Jan 2024 19:41:59 GMT

celen 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

Also, see MM3TR&R: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community

Re: Matrix and subtotals once again

celen — Wed, 31 Jan 2024 15:40:56 GMT

Hi,

Thanks for your input Greg_Deckler to my question and for your contribution to the community regarding this common problem.

In all other cases where I have had this similar problem, I've been able to solve with the SUMX and HASONEVALUE functions, but in this particular case I can't get the correct values. I would obviously need to take another approach to the whole calculation . I am sharing the link to an example file if someone out there has a solution to this.

https://1drv.ms/u/s!As9ODccqmpMAgaEMcoqC57yW4WQ4Iw

Best regards,

Christer

Re: Matrix and subtotals once again

Greg_Deckler — Thu, 01 Feb 2024 14:53:54 GMT

celen Let me see if I can take a look at the file.