cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Compare 2 measures with each other

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

1 ACCEPTED SOLUTION
Helper I

I find the solution  :

Mesure =
VAR Threshold = SELECTEDVALUE(Threshold[Threshold Rate])
VAR Rate = ROUND(sum('Octroi fintake'[Assiette_TN])/sum('Octroi fintake'[Montant DF]),3) /*Calcul for my measure*/
VAR Display = if(Rate<Threshold,"yes","no")
RETURN Display
3 REPLIES 3
Helper I

I find the solution  :

Mesure =
VAR Threshold = SELECTEDVALUE(Threshold[Threshold Rate])
VAR Rate = ROUND(sum('Octroi fintake'[Assiette_TN])/sum('Octroi fintake'[Montant DF]),3) /*Calcul for my measure*/
VAR Display = if(Rate<Threshold,"yes","no")
RETURN Display
Super User

@JbPa33 i think you should use meausure

IF Threshold =
IF([Total Rate]<[Total Threshold],"yes","no")

Helper I

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.