Solved: Calculate the Percentage - Page 2

a-simarg · ‎10-10-2018

Hi

Can someone help me with bellow?

I have a table with 2 columns:

Modality Clicks

chat 123

bot 23456

online 41

submission 2456

Total 26076

Now i want to calculate for each modality using visualization "card" the percentage for each from the total

Example: chat - 0.47%; Bot 89.9%

Thanks

Arentir · ‎10-10-2018

If you use card, then you will need a visual level filter for each of your card.

Your value can be this measure:

Measure = SUM(Table1[Clicks]) / CALCULATE(SUM(Table1[Clicks]),ALL(Table1))

You don't need to use total field, the calculate part will do that for you

Calculate the Percentage