Reply
Frequent Visitor
Posts: 7
Registered: ‎12-27-2018

Re: Problem using measure as argumentes in FILTER function

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.

AlB Super Contributor
Super Contributor
Posts: 1,166
Registered: ‎11-12-2018

Re: Problem using measure as argumentes in FILTER function

@IgorCT

 

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.

Frequent Visitor
Posts: 6
Registered: ‎11-15-2018

Re: Problem using measure as argumentes in FILTER function

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.

Highlighted
Frequent Visitor
Posts: 7
Registered: ‎12-27-2018

Re: Problem using measure as argumentes in FILTER function

First of all I would like to thank you for your help and availability. Follow the file link.

http://www.filedropper.com/test_33