Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I have this Slicer :
I would like to create a measure which retrieve the value "1,89%". As the slicer is a continue value, the function "SELECTEDVALUE" doesn't work.
Is There an another solution ?
Thank you
Solved! Go to Solution.
Hi @JbPa33 ,
As per documentation SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult. there are multiple values from 0 to 1.89%. In order to get 1.89% which is the highest in the range selected, use MAX instead.
Thnak you for your answers !
You can use the below measure to return the 1,89%
measure = MAX(table[fieldname])
Hi @JbPa33 ,
As per documentation SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult. there are multiple values from 0 to 1.89%. In order to get 1.89% which is the highest in the range selected, use MAX instead.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 46 |