Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I would like to display a listing of contracts according to a selectedValue :
On the left, there is a slicer to choose the Threshold and I would like, in the right table, display the contract which have a rate inferior than the Threshold. The Data "Rate" is a measure, i tried to create a New measure "Display = if([rate] < selectedvalue(Threshold rate),"Yes","No")" but it doesn't work because this measure compare the total values.
How I could do to display only the contracts which have a rate inferior than the threshold choosen ?
Thank you
Solved! Go to Solution.
I find the solution :
I find the solution :
@JbPa33 i think you should use meausure
Thank you for your answer but I have already tried to use a measure and it doesn't work. In your example, "Total Threshold" isn't a constant whereas in my report, this value is selected by a slicer.
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |