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

[lucasbarros]

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: 

This is the graph before: 

What I want here is hide the others countries. 

Someone here able to help me with this? 

Many thanks in advance




  

[v-kelly-msft]

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!

[amitchandak]

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]))