cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Matrix not showing correct totals for duplicate values

I have a live connection to AAS in my Power BI Desktop report.  Within my report, I used a matrix visual to show product hierarchy totals.  My issue is the matrix is not showing the correct totals when one of the products (U404) is listed in two separate product categories. The matrix appears to sum only one of the duplicates when creating the grand total. For example: U404 product is part of V27 and V456 product categories.  I used DAX SUM formula to get the Sum column.  How do I get the grand totals to reflect the correct totals?

 

 

4 REPLIES 4
Super User II
Super User II

Hi @cf4394 ,

 

Check the following existing thread on this:

https://community.powerbi.com/t5/Desktop/The-total-in-matrix-is-not-correct/m-p/1151209

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Super User IV
Super User IV

@cf4394 , can you share the formula. Can you share sample data and sample output in table format?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Community Support
Community Support

Hi @cf4394 ,

 

What's your DAX formula? It's best to provide some sample data for test. Please remove sentitive information.

 

 

Best Regards,

Icey

Community Support
Community Support

Hi @cf4394 ,

 

Have you solved this problem?

 

 

Best Regards,

Icey

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors