powerbi matrix visuals shows wrong numbers

Hi anglefbi11 ,

The problem seems to be related to the filter context.

The most relevant information you need to master about evaluation contexts is the difference between the row context and the filter context. You cannot appreciate any difference until you know exactly what the two contexts are.

This link can help you:

Filter context in DAX - SQLBI

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

anglefbi11 Pie Chart (Highlight Option):

When using the highlight option, the pie chart shows a portion of the data while still displaying the overall context. This means that the percentage calculation can be more accurate because it retains the full data set context, showing how much of the whole is highlighted.

When you use the filter option, the pie chart only displays the filtered subset of the data. If the percentage appears wrong, it might be because the filter changes the context of the data, leading to a different calculation for the measure. This can result in the measure being evaluated only on the filtered data set, which may not match your expectations.

Solution

Here’s an example of how you might write a DAX measure to correctly handle context:

Ensure that your measure is context-aware and correctly handles the different contexts it is evaluated in. You might need to use DAX functions such as CALCULATE, ALL, or FILTER to control how the context affects your measure.

CorrectedPercentage =
VAR TotalValue = CALCULATE(SUM(Table[Value]), ALL(Table))
RETURN DIVIDE(SUM(Table[Value]), TotalValue, 0)

This measure calculates the percentage of the total value regardless of filters applied, ensuring consistency across different visuals.

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!