DAX : possible to create a table with 2 fields from 2 different tables

[Bebs]

Hi, I've a model like this :

Fact_Table:

Product, Customer_ID

P1, C1

P2, C1

P3, C2

....

Dim_Table:

Customer_ID, Customer_Region

C1, Region1

C2, Region2

I would like to get the list of Product from Region 1 (Important : Without using the function CALCULATE)

How can I write this in DAX ?

(My main difficulty is a lot of DAX Function such as Summarize or Filter only seems to apply to one Table).

Thanks

[qqqqqwwwweeerrr · Accepted solution]

Hi @Bebs 

I am not sure if i can understand the problem. Here is my approach if join both the tables then it should slove the problem 

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

check out my other instering video here: www.youtube.com/@Howtosolveprobem

Reagrds