HELP ME COMPARE SOME MEASURES AND COLUMNS

[Anonymous]

Hi.

Im trying to do this:

First I create this measure with  columns of a lot of data:

MTTR febre = IFERROR((SUM(MTTR_MTBF[TP Feb]))/(SUM(MTTR_MTBF[NE Feb]));0)

Then i create the following table:

Where [MTTR máx (horas)] and [MTTR promedio (horas)] are just those datas

Now I want to compare the above data in a measure like this:

A33 = IF([MTTR FEBRE]>VALUE([MTTR máx (horas)]);"Insuficiente";IF([MTTR febre]<VALUE([MTTR promedio (horas)]);"Excede";IF(AND([MTTR FEB]<VALUE([MTTR máx (horas)]);[MTTR febre]>VALUE([MTTR promedio (horas)]));"Meta";"No")))

BUT I CAN´T DO IT!!!!!!!! Power BI dont let me do this measure, because when i am making the formula power bi only let me call the measure MTTR febre and not the columns [MTTR máx (horas)] and [MTTR promedio (horas)].

Do you have any suggestion? please.

I´m desperate

[az38 · Accepted solution]

Hi @Anonymous 

try to use SELECTEDVALUE([Measure]) in comparision formulas like SELECTEDVALUE([MTTR FEBRE])

do not hesitate to give a kudo to useful posts and mark solutions as solution