Forum Discussion
Connecting a Measure to a Slicer
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?
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:
Hope this can help.
Best Regards,
Giotto Zhi
2 Replies
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:
Hope this can help.
Best Regards,
Giotto Zhi