Forum Discussion
Measure using a non active relation
Hello all
From a great DB where I can find orders, sells, purchasing and other documents, I have many dates collumns (such as document creaton date and deliery date). I have this big DB linked to a continous calendar table so I can do some meassures based on the creation date, but I am having problems creating meassures by the delivery date.
This Delivery Date collumn is linked to the calendar date via a non active relation
Do you have any idea how I can do a meassure based on the delivery date, such as "Total expected sells within X month of the year"? In simple terms would be
Total sells = calculate (sumx(big DB, EUR), delivery date = calendar date.month)
But this doesn't work.
Below images on how my tables are linked and the current error of linkage from a related table
Thanks!!
6 Replies
Hi Anonymous, you need to use the function USERELATIONSHIP, please check here how to use it: https://learn.microsoft.com/en-us/dax/userelationship-function-dax
If my answer fullfil your question, please mark it as a solution
Like this
Total sales = CALCULATE( SUXMX(table, table[EUR] ) , USERELATIONSHIP( table[delivery date], calendar[date] ) )
Hi Anonymous,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Deku and MattiaFratello for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Hi @fabi89,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
