Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |