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.
You can place the file on platforms like Dropbox, OneDrive, etc. or upload it to sites like this (no sign-in required) and then share the URL here.
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.
First of all I would like to thank you for your help and availability. Follow the file link.
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Get your latest community news and announcements.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Each week, complete activities and be qualified in the drawing for cool Power BI Swag.