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:   Name Local Grade Country Salameh, Mario Partner USA Berli...
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] ) )
)
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] ) )
)