Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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:
Hope this can help.
Best Regards,
Giotto Zhi
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
Yes, it works perfectly! It is an elegant solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |