March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Dear experts,
I've built a pie chart to show orders per supplier and a card to display the number of orders. They work pretty well. When clicking each supplier, the value on the card charges accordingly.
However, when I wanted to add another card to show the percentage of the total, it didn't work. The data I put in the field is Count(distinct) of Order# and show the value as percentage of grand total. Initially it displays 100%. But it doesn't change as I click each supplier.
Can you help to let me know how to fix it?
Thanks
Andrew
Hi @andrewlxwl ,
Demo file attached.
Please try below formula in your card:
Count Grand Total =
DIVIDE( CALCULATE( DISTINCTCOUNT('Table'[Order#])), CALCULATE(DISTINCTCOUNT('Table'[Order#]),ALL('Table')))
Best Regards,
Joyce
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.