Last answered:

22 Aug 2023

Posted on:

20 Aug 2023

0

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)
Posted on:

22 Aug 2023

0

You can use a measure like this as a denominator:
% of US Market Share = sum(sales)/calculate(sum(sales),allselected(country[name]))

Submit an answer