How to show filtered vs total data in power BI

Question

How to show total sales of a country vs total sales of all countries?

Answer 1

Hi sindhu,

Follow below steps to show filtered vs total sales.

1. Create a slicer and add country.

2. Create a bar chart with country and sales.

3. Create measure Total Sales = CALCULATE(SUM(Orders[Sales]),ALL(Orders[Country]))

4. Create measure Filtered Sales = Ceiling(SUM(Orders[Sales]))

4. Now create 2 cards one for total sales and another for filtered sales.

5. Now add the country in the filter. You can observe the filtered vs total sales.

Hope this helps you.