Share via

Count and percentage of each subcategory of a category in Power BI?

Anonymous
2024-01-31T15:47:19+00:00

I have these data

Priority SLA Breached Number
P1 Yes INC0000
P2 No INC0001
P3 Yes INC0002
P3 No INC0003
P4 No INC0004
P4 No INC0005
P5 Yes INC0006
P5 Yes INC0007

and I want output as below. Any help will be appreciated

Priority Total tickets % of No
P1 1 0
P2 1 100
P3 2 50
P4 2 100
P5 2 0
Microsoft 365 and Office | Install, redeem, activate | For education | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-02-02T14:21:52+00:00

    Hi Mousumi,

    Thanks for posting back. I'm glad to know it works well now. Also, if you encounter any issues while using Office products, such as Word issues, please feel free to post in our community and we are glad to help.

    Sincerely,

    George | Microsoft Community Moderator

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-02-01T08:18:05+00:00

    I was facing issue yesterday while completing profile in Power BI community. Anyway it worked later and I posted there also. Thanks

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-01-31T20:04:56+00:00

    Hi Mousumi,

    Thanks for posting in the community.

    We would love to help you with your query, however, since your situation is related to Microsoft Power BI, and we have a specific channel Microsoft Power BI Communitycoping with such Power BI questions, I recommend you post a new thread there for expert help.

    Sorry for that our category may have limited resources to check on your concern further. Appreciate your understanding and patience.

    Sincerely, 

    George | Microsoft Community Moderator

    Was this answer helpful?

    0 comments