Problem calculating percentage total - bar chart

Hello v-yuta-msft,

The 100% represents the sum of all columns related to a Product (Produto).

I created a new scenario to simulate the problem. I reduce the number of fields to make it easy.

Dashboard Simulation

The dataset that I used is:

I’m using two bar charts to check and to explain the scenario.

The barchart below I use just to check the values, notice that if you sum de percentage the value is 100% (23,08% + 15,38% + 23,08% + 15,38% + 23,08%). I also filter this chart by the “Produto” that I need to check.

Chart to verify percentage

Here is how I configured it.

Chart 1 - set up

This second barchart represents the comparison between my “Produtos”, I use a measure to calculate the value.

The measure (“medida”) formula is: Medida = DIVIDE(COUNT('chamado-ms'[Faixa]);CALCULATE(COUNT('chamado-ms'[Faixa]);ALLEXCEPT('chamado-ms';'chamado-ms'[Familia];'chamado-ms'[Produto];'chamado-ms'[BR];'chamado-ms'[Regional])))

Chart 2 - Comparison between "Produtos"

Here is how I configured chart 2.

Chart 2 - set up

Now I will show two scenarios, the first one is when it works properly and the second one is when I get the unexpected behavior.

Scenario 1: Filtering only by “Produto”.

scenario 1

The values related to “Produto” Blue-Ray are equal in both charts, if we sum the values we get the value 100% (23,08% + 15,38% + 23,08% + 15,38% + 23,08%).

The value when we sum the second product “TV” is also correct (100,01%).

Scenario 2: Filtering by “Produto” and “Regional”.

Scenario 2

When I add this filter, my measure “medida” calculates the value incorretly.

How could I fix it? I have no idea about the reason of this behavior :(

Best regards

Roger