Display simple summary of text column

[adavid999]

Hello, a simple question - I have a column of text in Power Query Editor comprising data either 'cats' or 'dogs'.

How do I display these categories on a card in Power Bi Desktop Report as a percentage of all. E.g 48% cats, 52% dogs?

Thanks,

A

[Anonymous · Accepted solution]

Create measure

Total cat= calculate(Count(Table[Column]),filter(table,table[Column]="Cat")

Total dog= calculate(Count(Table[Column]),filter(table,table[Column]="dog")

Total=Count(Table[Column])

%cat=divide([Total cat],[Total])

%dog=divide([Total dog],[Total])

drag above two measures in card.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[adavid999]

Very helpful, thanks.

A