Count with filters

[Anonymous]

Hi,

I've been trying to find a solution with the below scenario. I hope someone can help.

I have the following data:

Name	Local Grade	Country
Salameh, Mario	Partner	USA
Berlin, Martin	Partner	USA
Khan, Jawad	Partner	UK
Mackenzie, Karl S	Senior Manager	Spain
Masry, Raed A	Senior Manager	USA
Ghanghro, Mossadiq A	Manager	Spain
Bhatt, Mihir	Manager	UK
Sobh, Mohamad A	Senior	Spain
Hussein, Omar Z	Senior	USA
Karmakar, Anirban	Junior	UK
Mcpheator, Craig A	Junior	USA
Zabalawi, Zaid H	Junior	Spain

I have a slicer for Local Grade, and what I am trying to do is that when I filter on partners for example I want to see the percentage of partners in comparison to all other local grades for each country alone ( Not as a percentage of partners across all countries)

So If I select on Partner I should get the following:

USA 40 %

UK  33.3 %

Spain 0 %

What I did was that I used the following measure:

measure = CALCULATE(COUNTROWS(FILTER(Sheet3, Sheet3[Local Grade] = "Partner")))

 and then I divide  this measure by the total number of rows in sheet 3

But this will always give me the percentage of partners in each country even if I change the slicer to senior manager.

[Zubair_Muhammad · Accepted solution]

@Anonymous

Something like this may be

Measure =
DIVIDE (
    COUNT ( Table1[Country] ),
    CALCULATE ( COUNT ( Table1[Country] ), ALL ( Table1[Local Grade] ) )
)