Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
celen
Frequent Visitor

Matrix and subtotals once again

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?

celen_0-1706642938489.png

Br,

Chris

3 REPLIES 3
celen
Frequent Visitor

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

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Community Champion
Community Champion

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.