Card Visual not change

[andrewlxwl]

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

[isjoycewang]

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