Switch between ID/assign to another ID

[Anonymous]

Hi.

I don't have a sample dataset so I will try my best to describe my question. 

I have three tables:

• Product
• Shoes
• Sales

I have a measure that calculates total sales by a product Id. Here is an example: 
Measure 1 = Calculate(sum(Sales[total]));Product[ProductId] = 1111)

But I want to assign Measure 1 to a ShoeId from another table. Something like this: 

Measure 2 = Calculate[Measure 1] where Product[ProductId] = 1111 is in Shoe[ShoeId] = 222222

Is this possible? 

Thanks

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Is this what you want? Maybe you can use matrix directly to sum sales.

(data model)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi,

but please use the "correct" (one-to-many) relationships.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

try to create a small sample dataset.

You can use the function "Enter data" for that.

https://docs.microsoft.com/en-us/power-bi/desktop-enter-data-directly-into-desktop

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

Hi @mwegener ,

Thank you for trying to help me. 

Sales table

Sales	ProductFK	ShoeFK
34	123	21
65	124	23

Product table

ProductPK	Product code	Product name
123	11111	Beans
124	11114	Billy

Shoe table

ShoePK	Shoe code	Shoe name
21	222222	Green

Now, I want to have a measure that calculates the total sales for Product code=1111, but I want to "assign" it to Shoe code= 222222 instead. Because products can have many shoes, so I just want to assign it to one shoe which is 222222