Calculate the Percentage

[a-simarg]

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 · Accepted solution]

Hi @a-simarg

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

[a-simarg]

the percenatge works but now when i choose different months the percentage remains the same for every months..

[Arentir]

@a-simarg,

Sorry didn't have a full view on your model. The calculate ignore any filter so the total is for the whole table. If you want the ratio to work for filtered date, have the ALL only applying to modality field:

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

[Anonymous]

Looks like the filters are not propogating correctly.

Can you provide screenshots?

[a-simarg]

in a table, the data is changing while i am selecting different months..

[a-simarg]

[Anonymous]

You can use the in-built feature.

[a-simarg]

It is true yes, but when you filter , and choose for example Modality Chat, what percentage shows you?

[Anonymous]

You are correct, a measure is better.

---

@a-simarg wrote:

It is true yes, but when you filter , and choose for example Modality Chat, what percentage shows you?

---

[a-simarg]

This only worked!

thakns a lot

you are awsome!