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
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Could you please share your pbix to me? You can upload the pbix to dropbox and share the link here.

 

Regards,

Frank

  • Ronald123's avatar
    Ronald123
    Icon for Resolver III rankResolver III
    7 years ago

    Hello Anonymous,

     

    Try this measure;

     

    Cobertura: = CALCULATE(
                     SUM(DatosRF[Cobertura]);
                     DatosRF[Frecuencia]=2)

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      The problem is that it is not a fixed number (it's not always 2). The result of the measure can be any value, it is variable.
      • Ronald123's avatar
        Ronald123
        Icon for Resolver III rankResolver III
        7 years ago

        Hi Anonymous,

         

        You can use a slicer, put in the slicer the colum DatosRF[Frecuencia].

         

        Greets,

         

        Ronald