Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
@boxen_solution the issue might be your measure, how are you calculating the total?
Proud to be a Super User!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |