cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IgorCT Frequent Visitor
Frequent Visitor

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.

Super User
Super User

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.

luisenpons Frequent Visitor
Frequent Visitor

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
IgorCT Frequent Visitor
Frequent Visitor

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 221 members 2,425 guests
Please welcome our newest community members: