Connecting a Measure to a Slicer

[Anonymous]

I have a table with a list of countries (USA, FRANCE, GERMANY, ETC...). Each country has a index value next to it. I use this table to create a slicer on my report.

I need a measure that will change the country based upon the input that is chosen in the slicer (e.g. if someone chooses USA, then the measure will update the report to the USA data; if someone chooses France, then the measure will update to France.

Is there a way to do this?

[v-gizhi-msft · Accepted solution]

Hi,

For your requirement, i create a sample to show:

If you want to show the total sum sales for the country you select, please try this measure:

Measure = CALCULATE(SUM('Table 2'[Sales]),FILTER('Table 2','Table 2'[Country]=SELECTEDVALUE('Table 1'[Country])))

Choose [Country] from Table 1 as a slicer and this measure as a card visual, when selecting one country in slicer, the result shows:

Here is my test pbix file:

pbix 

Hope this can help.

Best Regards,

Giotto Zhi

[Anonymous]

Yes, it works perfectly! It is an elegant solution.