topic Re: DAX to create columns using userelationship in DAX Commands and Tips

DAX to create columns using userelationship

sam_gift — Tue, 31 Oct 2023 20:09:48 GMT

Hi Have 2 tables. Customer and Fact

Customer:

Fact:

They have 1 active and 2 inactive relationships.

How can I create a table with all the Payer, Billed and shipped customers information with revenue.

I have to use only dax not power query.

Please help

Re: DAX to create columns using userelationship

FreemanZ — Wed, 01 Nov 2023 01:45:40 GMT

hi sam_gift ,

not sure if i fully get you, you may plot a table visual with customer[customer_key] with three measures like:

RevenueByPay = SUM(fact[Revenue]) RevenueByBill = CALCULATE( [RevenueByPay], USERELATIONSHIP(fact[BillToCustomerKey], customer[customer_key]) ) RevenueByShip = CALCULATE( [RevenueByPay], USERELATIONSHIP(fact[ShipToCustomerKey], customer[customer_key]) )

it worked like: