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?
@boxen_solution the issue might be your measure, how are you calculating the total?
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)
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
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!