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 like this:
I have a slicer.
As long as I keep the slicer to single select, this Measure retrieves the correct result:
Measure = calculate(
What am I missing?
TYIA.
Solved! Go to Solution.
@kressb You can't use SELECTEDVALUE when there is more than one value, otherwise it will return the "alternate result". You need to get the values using VALUES or DISTINCT and use the IN operator.
@kressb You can't use SELECTEDVALUE when there is more than one value, otherwise it will return the "alternate result". You need to get the values using VALUES or DISTINCT and use the IN operator.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |