Forum Discussion
Create a DAX relationship
Hi,
I have a situation where i have two tables: Category and Products. I want to combine these to a visual. However, this would require a relationship that links Product 1,2,3,4 to "Products" category. I could just create a calculated column for this, but that would be redundant.
Can i create this relationship with DAX? How?
Hi CarlsBerg999 ,
Based on your description, I create a measure as follows.
test =
SUMX(FILTER(ALL('Products'),LEFT(MAX('Products'[Products]),3)=LEFT(SELECTEDVALUE('Categories'[Categories]),3)),[Price])Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
CarlsBerg999 , Created a calculated column is an idea going to work here. Is the service also have data coming from another table?
Yes, I would like to avoid making calculated columns. Isn't there a way to create this relationship with a measure?
The ideal step will be create a Key column then make a relationship by virtual or physical..
if you dont want to create any column then simple Switch or if statement also will help you to acheive this
Attached is the .pbis file for your reference
https://dropfiles.org/Z5M3DH7C
Hope it will help
Regards
sanalytics
Hi CarlsBerg999 ,
Based on your description, I create a measure as follows.
test =
SUMX(FILTER(ALL('Products'),LEFT(MAX('Products'[Products]),3)=LEFT(SELECTEDVALUE('Categories'[Categories]),3)),[Price])Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
