Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

DIGAR

Problem with subtotal in matrix

Submitted by on ‎02-18-2022 02:10 AM

 

bug BI.JPG

I work with this matrix.
As can be seen from the image, the total of the third column is incorrect.
why does this happen? how can i correct the visualization?

 

regards

Status: Investigating

Hi,

The total incorrect is a very common problem when you create a measure as the value field of the chart, you can use some methods to create a measure to replace the original measure to make the total correctly appear, please refer to these links:

https://archerpoint.com/how-to-make-measures-total-correctly-in-power-bi-tables/

https://blog.enterprisedna.co/why-your-total-is-incorrect-key-power-bi-concept/

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
1 Comment (1 New)
Comments
v-robertq-msft
Community Support
Community Support
‎02-20-2022 07:16 PM
Status changed to: Investigating

Hi,

The total incorrect is a very common problem when you create a measure as the value field of the chart, you can use some methods to create a measure to replace the original measure to make the total correctly appear, please refer to these links:

https://archerpoint.com/how-to-make-measures-total-correctly-in-power-bi-tables/

https://blog.enterprisedna.co/why-your-total-is-incorrect-key-power-bi-concept/

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses