card visual ...
In the event that I want to know the percentage of sales of each country (if I selected ) compared to US sales, and use the card visual ,
In other words, if I use the slicer chart and selected Canada, for example, I want the percentage of Canadian sales to be shown compared to US sales in the card visual , how can I do that please!
1 answers ( 0 marked as helpful)
You can use a measure like this as a denominator:
% of US Market Share = sum(sales)/calculate(sum(sales),allselected(country[name]))