Category count percentage by dividng it with total count of category column also based on slicers

[PowerBI__]

Hello,
I have got a below data:

Country	Company	Category
X	AB	A
Z	AC	A
Y	AD	B
Y	AB	C
X	AD	B
Z	AB	A
X	AC	B
X	AB	C
Y	AC	A
Z	AB	A

I was using below measure CategoryPercentage =
DIVIDE(
COUNT('YourTable'[Category]),
CALCULATE(COUNT('YourTable'[Category]), ALL('YourTable')),
0
)
to get the % but the when I use slicer of country or company the numerator gets slicer but due to ALL function demominator count of category remains same which makes category in that country divided by again total count of column rather then sliced by country slicer. I want if I do not select slicer then each category divide by total column count. But if I select slicer of country then each category available in that country divde by the category column count which was in that country. 
Basically I was looking to see only top 5 Categories % as all or once they are sliced by slicer of country and company.
Your hel would be highly appreciated.
Thank you

[shafiz_p · Accepted solution]

Hi @PowerBI__  Try this:

CategoryPercentage = 
DIVIDE(
    COUNT('YourTable'[Category]),
    CALCULATE(
        COUNT('YourTable'[Category]),
        REMOVEFILTERS('YourTable'[Category])
    ),
    0
)

Top 5 Categories

To show only the top 5 categories by percentage, you can use a visual-level filter:

1. Add a table or matrix visual.
2. Add the Category and CategoryPercentage fields.
3. Apply a visual-level filter to CategoryPercentage to show the top 5 items.

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz