Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help with Product combinations

Hi, I'm new with DAX and I have a question. I need the product combinations of the orders. I have an order table, an orderline table and a product table. What I want is to count the product combin...
Need Help
Show and Tell
Tips and Tricks
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi,  Anonymous 

Not very clear.Can you explain in more details?

How did you create the "Product Portfolio" column?Why does the value "SunSpray" exist in the expected table but the value "aftersun" does not exist?

 

Before creating report, you can  consider using function' lookupvalue' to integrate data from multiple tables into table 'Orderline'  first.

calculated columns:

Orderamount = LOOKUPVALUE('Order'[Orderamount],'Order'[Index],Orderline[Index])
Product = LOOKUPVALUE('Product'[ProductName],'Product'[ProductId],Orderline[ProductiD])
Price = LOOKUPVALUE('Product'[Price],'Product'[ProductId],Orderline[ProductiD])

 

 

Best Regards,
Community Support Team _ Eason