Filter on 2 Dim tables with OR condition

Question

Hi&nbsp;I have a fact table example below, but has another 60 columns and row count &gt;2 million&nbsp;Case IDShop IDProduct IDChannel ID&nbsp;abc126862101115600083735727676823&nbsp;&nbsp;These then have Dim tables, which have a hierarchy and has a relationship on the ID (One to Many)&nbsp;e.g., Product Dim table (the other tables are the same in that they have a hierarchy) - has &gt;50K records&nbsp;&nbsp;Product L1Product L2Product L3Product L4Product L5Product ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;560008373572&nbsp;Shop Table -has &gt; 900 recordsShop L1Shop L2Shop L3Shop ID&nbsp;&nbsp;&nbsp;10111&nbsp;I need to be able to filter for an OR condition&nbsp; e.g., Product L3 = "ABC" OR Shop L1 = "XYZ". How can i do this? I attempted to create a measure using crossjoin and filter however, when published the measure returns no results, so I assume this isn't the right solution. I could write an if statement in Power query, however, there are over 100 Product IDs as part of Product L3 = "ABC" so the formula would be massive and not very easy to adjust every time we've got a new product

mlsx4 · Accepted Answer

Hi&nbsp;Alpesh&nbsp;&nbsp;If tables are well connected, you should be able to do something similar to this using RELATED to take fields from other tables:FILTER('FactTable',
		RELATED(Products[ProductID]) = "ABC" || 
		RELATED(Shops[ShopID]) = "XYZ")
	)&nbsp;

Forum Discussion

Filter on 2 Dim tables with OR condition

2 Replies

Related content

Filtered table

Filtering a table with multiple conditions from multiple switches pulled from another table

Conditional Filtering

Conditional Formatting with Matrix Table

Grouped summaries with conditional filtering

Case ID	Shop ID	Product ID	Channel ID
abc126862	10111	560008373572	7676823

Product L1	Product L2	Product L3	Product L4	Product L5	Product ID
					560008373572