Percentage shifts when chart is filtered

AJ2020
AJ2020 ⚪️

Hi,

I am trying to make a card that shows the percentage of a client's total business is sent to us ("Company A"). I am using a beast mode and it works well until I try to apply a quick filter to look at clients that are over a certain percentage or filter by one Client. In one instance the percentage goes from 2% (correct) to 20% once filtered.

How can I get the real number to lock? Chart and beast mode below.

Thank you for your help.


Comments