One active relation when we need 2

[Roinka]

Hi,

I have a calendar dimension which holds the date and name of the day of the week and a sales fact table which holds details per sales. The sales table include both an order date and a stock date for every order.

I can join between the sales table and the calendar table based over the Sales.orderDate to Calendar.Date or based over Sales.stockDate to Calendar.Date but as you know only one relation may be active at a time.

Lets say i want to present 2 visuals. One will hold the profits per day of the week considering the orderDate and the other will hold the profits per day of the week considering the stock date.

Since we can only have one active relation between calendar and sales, how can we present the two matrix on the same report?

Thanks.

[AlB · Accepted solution]

Hi @Roinka 

Have you checked out USERELATIONSHIP? You could have one relationship active and the other inactive and activate the latter through USERELATIONSHIP in a CALCULATE

https://dax.guide/userelationship/