Forum Discussion
Card Visual not change
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 acc...
isjoycewang
Solution Supplier
Solution SupplierHi 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