Forum Discussion

Alpesh's avatar
Alpesh
Icon for Helper I rankHelper I
3 years ago
Solved

Filter on 2 Dim tables with OR condition

Hi   I have a fact table example below, but has another 60 columns and row count >2 million   Case ID Shop ID Product ID Channel ID   abc126862 10111 560008373572 7676823     T...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi Alpesh 

     

    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")
	)

     

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Alpesh 

 

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")
	)