Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count with filters

Hi,

 

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

 

I have the following data:

 

NameLocal GradeCountry
Salameh, MarioPartnerUSA
Berlin, MartinPartnerUSA
Khan, JawadPartnerUK
Mackenzie, Karl SSenior ManagerSpain
Masry, Raed ASenior ManagerUSA
Ghanghro, Mossadiq AManagerSpain
Bhatt, MihirManagerUK
Sobh, Mohamad ASeniorSpain
Hussein, Omar ZSeniorUSA
Karmakar, AnirbanJuniorUK
Mcpheator, Craig AJuniorUSA
Zabalawi, Zaid HJuniorSpain

 

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.

 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    Something like this may be

     

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

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous

     

    Something like this may be

     

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