Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

filter with measure

Good afternoon, I have the result of a measurement, which I need to use as a "filter" of a table. That is, I need to see in a table only the rows in which the value of column "A" matches the result o...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Ronald123,

     

    To create a measure as below and filter the measure in the visual.

     

    Measure = IF(MAX(DatosRF[Frecuencia])=[V_Rango_Frecuencia_redondeado],1,0)

     

     

    Please check the pbix as attached.

     

    Regards,

    Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Ronald123,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.


    Regards,
    Frank

  • Anonymous's avatar
    Anonymous
    7 years ago

    THANKS FOR YOUR ANSWER. IT IS NOT WHAT I WAS LOOKING FOR, ALTHOUGH I BELIEVE THAT WHAT I WANTED TO DO IS NOT POSSIBLE. I THANK YOU VERY MUCH OF YOUR TIME.

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Ronald123,

 

To create a measure as below and filter the measure in the visual.

 

Measure = IF(MAX(DatosRF[Frecuencia])=[V_Rango_Frecuencia_redondeado],1,0)

 

 

Please check the pbix as attached.

 

Regards,

Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Ronald123,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.


    Regards,
    Frank