Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Problem using measure as argumentes in FILTER function

I am new here,

I would like help solving a problem! I'm trying to filter a table passing to a measure's FILTER function, but it does not return values, when I substitute the same measure for "text" values ​​return correctly.

　

Summarized Table = FILTER (OriginalTable; OriginalTable [field1] = "TEST")    -   OK

　

Summarized Table = FILTER (OriginalTable; OriginalTable [field1] = [measurement returning "TEST"])      -     NOK

Need Help

13 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

     

    Are you sure it's not context transition playing tricks? Do bear in mind that every time you invoke a measure, the DAX engine wraps the call in a CALCULATE. That in your case would trigger context transition since you have a row context in FILTER( )

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for your help!

      I'm new to the DAX language, could you kindly send me an example of using the FILTER function with measure as an argument?

      I am wanting to filter the row of a table to bring an argument to the media and filter another table with this measure.

       

       

       

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        Anonymous

         

        can you show the code of your measure?