Measure using a non active relation

[fabi89]

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!!

[v-achippa]

Hi @fabi89,

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

[v-achippa]

Hi @fabi89,

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

[v-achippa]

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

[MattiaFratello]

Hi @fabi89, 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

[Deku]

Like this

Total sales = 
CALCULATE(
   SUXMX(table, table[EUR] )
   , USERELATIONSHIP( table[delivery date], calendar[date] )
)

[fabi89]

So far does not retrieve any error, but does not calculate it. I want to add every order to be delivered within EOM of each Month, Year

In other words, I want to reply the question "How much do we expect to invoice within the ending of X month"

Any ideas?