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

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.