Create a DAX relationship

[CarlsBerg999]

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?

[v-yuaj-msft · Accepted solution]

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.

[sanalytics]

@CarlsBerg999 

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

[amitchandak]

@CarlsBerg999 , Created a calculated column is an idea going to work here. Is the service also have data coming from another table?

[CarlsBerg999]

Yes, I would like to avoid making calculated columns. Isn't there a way to create this relationship with a measure?