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
Anonymous's avatar
Anonymous
Not applicable
7 years ago


I do not have clever information in this article. How can I send it to you?

I'm basically trying to filter a table with filter info without they are interconnected.

 

 

Thank you very much in advance.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for everything!

One more question, can I use SELECTEDVALUE inside the FILTER function to return a filtered table with the context value? As below. 

 

Aux Table = FILTER(Table2;Table2[Col1] = SELECTEDVALUE(Table1[Cod];""))

 

I tried more does not return any value.

  • luisenpons's avatar
    luisenpons
    Frequent Visitor
    7 years ago

    You may want to look at ALLSELECTED, in case the filter is multiple:

     

    CALCULATE(Table1;ALLSELECTED(Table2[Col]))

     

    I recommend you to follow Introduction to DAX Course by SQLBI guys, Marco and Alberto. You will have really good insights into it.

     

    In this case, there is a video explaining ALLSELECTED in detail within Evaluation Context Section of the course.