Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |