https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786451#M147896 <P>Measures are all about context: page filters, slicers, rowcontext alltogether determine the resulting context. However, any part of context can be expanded or filtered further down using CALCULATE. If you create a measure, e.g. [averge months active] you can have that ignore all context by using CALCULATE([average months active], ALL())</P> Fri, 22 Mar 2024 14:48:10 GMT sjoerdvn 2024-03-22T14:48:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786030#M147885 <P>Hi!</P><P>&nbsp;</P><P><SPAN>The table below shows the number of active contracts (#) at previous month ends (Månad) for a particular customer, the original end date of the contracts ("**bleep**") and in which month the contracts actually ended - if ended (max). Based on this information I can create a measure to calculate the average number of days/months between the termination date and the original end date for the contacts that have been terminated before February 2023.</SPAN></P><P><img /></P><P><SPAN>As a next step I would like to use this average to calculate the estimated termination date (Beräknat slutdatum) for the contracts that are still active in February 2023. So, if, for example, the average contract (based on the previous measure) is terminated 150 days before the original end date (ÅrMånadSlut), and the end date is October 31</SPAN>st<SPAN>&nbsp;the estimated termination month would be May 2024, if the end date is in February 2025, the estimated termination month would be September 2024 and so on. So in the example below, the estimated termination date would be five months before the value in the ÅrMånadSlut-column. But I can’t find a way to use the measure (that was calculated for the contracts terminated before February 2024) as this visual only handles the contracts that are still active in February. Is it possible to use a “non-context” measure like that or is there another way to achieve this?</SPAN></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 22 Mar 2024 11:30:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786030#M147885 GGuru 2024-03-22T11:30:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786451#M147896 <P>Measures are all about context: page filters, slicers, rowcontext alltogether determine the resulting context. However, any part of context can be expanded or filtered further down using CALCULATE. If you create a measure, e.g. [averge months active] you can have that ignore all context by using CALCULATE([average months active], ALL())</P> Fri, 22 Mar 2024 14:48:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786451#M147896 sjoerdvn 2024-03-22T14:48:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786643#M147901 <P>Ah, thanks. That's great. Wasn't aware of the () for the ALL.&nbsp;</P> Fri, 22 Mar 2024 16:11:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-a-non-context-measure/m-p/3786643#M147901 GurraGuru 2024-03-22T16:11:11Z