12-28-2018 10:07 AM
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.
12-29-2018 12:36 AM
12-29-2018 01:12 AM
You may want to look at ALLSELECTED, in case the filter is multiple:
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.