Storing a calculated average value as a constant to use in future dated calculations

[JohannSteyn]

Hi all,

I have a calculation to calculate the average % of orders that are cancelled over the last 3 months (see below).

Let's say this number is 30%.

I want to use this 30% and apply it to the future orders that have been placed to estimate how many will be cancelled.

However, when I write the following DAX code, then the measurement is only applying the calculation on the last 90 days and not using the 30% as a constant in the future. How can I change this?

[JohannSteyn]

@amitchandak sorrry I made such a stupid mistake. Here's the corrected version if it will help anyone:

Thank you for the help

[amitchandak · Accepted solution]

@JohannSteyn , Can you add all('Collection table') in the filter first var. If needed need add filter do same in second var too

[JohannSteyn]

@amitchandak thank you for the reply.

Unfortunately I am getting this error below - any idea what I should change?