Problem with percentage of categorical data

[Vsaez]

Hello everyone

I am learning Power BI, so this question may seem easy to you.
I have a report where all the visuals, tables, etc, come from a dataset that only has categorical data, accompanied by an ID.
For example, if I want to calculate the frequency of a category, I count this ID, and so on with any type of visual that I want to add.

So, what they ask me now, in a graph that is filtered by Top N, is that the percentage that the graph shows is the percentage of the total, not the value filtered in the top N.

Example:
The first category has 35,097 cases, so its percentage with respect to the total data (117,672) is 29.8%. The graph now shows me that value as 36.8%.

How can I go about calculating this? I know that when they are numerical values it is easier, but since the value in this case is an ID, I don't know how to do it ...

Thanks a lot

[v-xulin-mstf]

Hi @Vsaez,

Is your issue solved?

I see your expect output in the attached pbix file.

Best Regards,

Link

[Jihwan_Kim]

Hi, @Vsaez 

I think you are doing it in the correct way. However, if it is OK with you, please share your sample pbix file's link here, then I can try to look into your measure and try to solve the issue.

thank you.

[Vsaez · Accepted solution]

Thanks @Jihwan_Kim 
https://drive.google.com/file/d/13-xZijRGkqCOvVPb0c10Z0QxHA6N4lch/view?usp=sharing

I hope that link works
as I am new, I don't know if there is another way to add it here.

thank you very much again