Forum Discussion
Problem using measure as argumentes in FILTER function
Anonymous
What table are you doing the FILTER( ) operation on? The Table1 you are referring to in the measure??
Thanks for everything!
I want to display in the table aux the selected item in the filter table.
- luisenpons7 years agoFrequent Visitor
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.
- AlB7 years agoCommunity Champion
Anonymous
Can you share the pbix file itself? With dummy data if there's confidential stuff on it.
Have you tried to use the code for the measure directly in the filter condition instead of calling the measure?
- Anonymous7 years agoNot applicable
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.
- Anonymous7 years agoNot applicable
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.
- Anonymous7 years agoNot applicable
First of all I would like to thank you for your help and availability. Follow the file link.