Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! 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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
75 | |
72 | |
69 | |
45 | |
41 |
User | Count |
---|---|
63 | |
41 | |
30 | |
28 | |
28 |