Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Anonymous
Not applicable

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.

 

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Something like this may be

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Something like this may be

 

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

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.