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" ...
Need Help
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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        Yes for sure. I always select only one row of the table. Measure = VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT(‘Table1’[Colun1]) VAR __MAX_VALUES_TO_SHOW = 1 RETURN IF( __DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW; CONCATENATE( CONCATENATEX( TOPN( __MAX_VALUES_TO_SHOW; VALUES(‘Table1’[Colun1]); ’Table1’[Colun1]; ASC ); ’Table1’[Colun1]; ", "; ’Table1’[Colun1]; ASC ); ", etc." ); CONCATENATEX( VALUES(‘Table1’[Colun1]); ’Table1’[Colun1]; ", "; ’Table1’[Colun1]; ASC ) )