"Select All" is different from selecting all.

[boxen_solution]

Hello

I have a table where users can filter by a text column. If all available selections is "ticked" manually the total data is correct:

BUT if i let the slicer select all selections by ticking "Select All". The values and totals in column 4 gets corrupted. 

What is the reason for this behaviour. Is it a bug or is there somthing in the datamodel that can introduce this behavior?

Best Regards

Mike

[v-huizhn-msft]

Hi @boxen_solution,

I am unable to reproduce your scenario, from your screenshot, I notice there is another year slicer in your report, right? If it is, please examine the interaction between slicers and reports. I think the issue is related it.



Thanks,
Angelia

[vanessafvg]

@boxen_solution the issue might be your measure, how are you calculating the total?

[boxen_solution]

Hi!

The total is calculated by the system (and behaves different if a "select all" or manually "pick all")

The measure for each row is like this

Förändring aktiva medlemmar procent = SUMX(DimDate;([Förändring aktiva medlemmar] / CALCULATE(SUMX('Månadsrapportering';'Månadsrapportering'[Aktiva medlemmar totalt]);PARALLELPERIOD('DimDate'[Datum];-1;MONTH))) *100)

BR