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

How can I use a measure with "ALL" in a slicer?

Hello everyone. 

 

I have this measure: 

Recognition (eCard) rate compared to global average = (([Number of E-cards distribucted]/[Global Population]))/[Recognition (eCard) received Avg.]-1 

The red part is calculated with another measure. This one have the "ALL" function, to not be affected by filters. 

Here is the measure: 
 
Recognition (eCard) received Avg. = CALCULATE([Number of E-cards distribucted];ALL('Overview Country ARE EE'))/CALCULATE([Global Population];ALL('Overview Country ARE EE'))

So, this is actually working. I mean, it's calculating well. 

The problem is: When I apply this first measure in a Slicer, I can't interact with a slicer, filtering only the countries that I need. 

For a example: 
I'd like to filter this values by Zone, to be able to see only the countries in a specific zone. 
Ex: Zone: Latin America -> I want to show only Latin America Countries (Argentina, Brazil... ) but PowerBI doens't hidethe other countries. 

I want to see only the countries in that specific group: 


Here some pictures: 
This is the graph without apply a slicer: 
e.g 1.png
 
This is the graph before: 
 
2.png
 
What I want here is hide the others countries. 

Someone here able to help me with this? 

Many thanks in advance




  

 

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: How can I use a measure with "ALL" in a slicer?

did not get completely

But If you only want to filter the country and others to Work. Make sure Country in other dimension and try like

Recognition (eCard) received Avg. = CALCULATE([Number of E-cards distribucted];ALL('Overview Country ARE EE'[country]))/CALCULATE([Global Population];ALL('Overview Country ARE EE'[country]))

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: How can I use a measure with "ALL" in a slicer?

Hi @lucasbarros

 

What's in [Number of E-cards distribucted] and [Global Population]?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors