Forum Discussion

andrewlxwl's avatar
andrewlxwl
New Member
2 years ago

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 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

Need Help

1 Reply

  • isjoycewang's avatar
    isjoycewang
    Solution Supplier
    2 years ago

    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