Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!!
Reagrds
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!!
Reagrds
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |