Forum Discussion

Bebs's avatar
Bebs
Icon for Helper II rankHelper II
2 years ago
Solved

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

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

Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

1 Reply

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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