cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
boxen_solution Frequent Visitor
Frequent Visitor

"Select All" is different from selecting all.

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:

okfilter.PNG

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

not ok filter.PNG

 

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

3 REPLIES 3
vanessafvg Super Contributor
Super Contributor

Re: "Select All" is different from selecting all.

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

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
boxen_solution Frequent Visitor
Frequent Visitor

Re: "Select All" is different from selecting all.

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

v-huizhn-msft Super Contributor
Super Contributor

Re: "Select All" is different from selecting all.

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.

1.PNG

Thanks,
Angelia

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 204 members 2,462 guests
Please welcome our newest community members: