Adding totals to a table visualisation

[Anonymous]

Hey All,
Any way to add totals to a table?
e.g. I want to count all red+yellow flags per column in the table below.

Cheers!
A

[v-xuding-msft]

Hi @Anonymous ,

You could create formulas using the function of IF, SWITCH to implement it.  There is no option to show the conditional sum directly. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-xuding-msft 
Thanks for the reply.

I know I can create my calculations. 

I am asking about the visual. Adding the numbers to a table. As you mention, is impossible.
As a work around, I have created another table to show my measures.

Cheers!
A