cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tamer_mn Occasional Visitor
Occasional Visitor

Filter table based on other table with if condition

hello,

 

the case is as follows:

i need to apply a filter on the table items; where it will filter based on a dimension in another table; meaning

if customer.market = "x" then item.buid = "y" else item.buid="z"

am trying to apply this on the advanced editor and since am new to DAX am its taking me forever to write the syntax correctly;

this is what i came up so far but its not working, cz its not recognizing market dim from the other table

 

#"Filtered Rows" = Table.SelectRows(BIDW_ITEM, each [ITEM_KEY] <> 123 and (each if BIDW_Customer[Market]="xx" then [BU_ID]="yy" else [BU_ID] = "zz")),

 

 

now i understand that the table.selectrows is being bound to scope of table item; but i tried filter and related functions and i cant seem to come up with the correct structure for the filter

am already goingin through tutorials on learning DAX from scratch, but it will need time

 

any help is much appreciated

 

regards,

2 REPLIES 2
Stachu Super Contributor
Super Contributor

Re: Filter table based on other table with if condition

does it have to be performed in single step?

if no, then I would:'

1) merge the two tables adding [BU_ID] to your original table

2) create new column with comparison

3) filter on that

4) remove unnecessary columns

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

BhaveshPatel Super Contributor
Super Contributor

Re: Filter table based on other table with if condition

You can use Conditional Column to achieve your desired output as it works on the If..Else logic, this will return you the expected result.

 

If you can post the sample data, I would be happy to provide you a solution.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

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: 139 members 1,664 guests
Please welcome our newest community members: