Problem with CALCULATE, lost the filter context

Question

Hi,&nbsp;This formula is good :Avg Delivery Days =&nbsp;AVERAGEX (&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; Delivery_Dte_Fioul_Particuliers,&nbsp; &nbsp; &nbsp; &nbsp; NOT (Delivery_Dte_Fioul_Particuliers[AGC_LIBC] IN {"x-VDSN","T-PSE Siège",""})&nbsp; &nbsp; ),&nbsp; &nbsp; Delivery_Dte_Fioul_Particuliers[DELIVERY DATE])&nbsp;This formula using CALCULTATE don't work :Avg Delivery DaysCalc =&nbsp;CALCULATE (&nbsp; &nbsp; AVERAGEX (&nbsp; &nbsp; &nbsp; &nbsp; Delivery_Dte_Fioul_Particuliers,&nbsp; &nbsp; &nbsp; &nbsp; Delivery_Dte_Fioul_Particuliers[DELIVERY DATE]&nbsp; &nbsp; ),&nbsp; &nbsp; Delivery_Dte_Fioul_Particuliers[AGC_LIBC] IN {"PACA","T-PSE Siège",""})&nbsp;[U]Le résultat[/U]&nbsp;&nbsp;AGC_LIBC &nbsp; &nbsp; &nbsp; &nbsp;Avg Delivery DaysCalc Avg Delivery Days&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,474247287 Brg Frnch Comte&nbsp; &nbsp; &nbsp;2,474247287 4,190534486Loire Auvergne &nbsp; &nbsp; &nbsp;2,474247287 2,703824046LVDR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,474247287 3,133449115Lyon PDA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,474247287 3,675738426PACA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,474247287 2,489297886Savoies &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,474247287 4,485062751T-PSE Siège&nbsp; &nbsp; &nbsp;2,474247287x-VDSN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,474247287&nbsp;Why when using CALCULTATE, the filter context don't work, but only a global average ?Thanks a lot

anonymous · Answer

Hi&nbsp;Loic_Pedro_Hans&nbsp;,
Please have a try.
measure =
CALCULATE (
    AVERAGE ( Delivery_Dte_Fioul_Particuliers[DELIVERY DATE] ),
    FILTER (
        ALL ( Delivery_Dte_Fioul_Particuliers ),
        Delivery_Dte_Fioul_Particuliers[AGC_LIBC] IN { "PACA", "T-PSE Siège", "" }
    )
)

&nbsp;
How to Get Your Question Answered Quickly&nbsp;
&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

loic_pedro_hans · Answer

Thanks Rongtie,I Try to do a best explanation for my problem.The problem is about CALCULATE.&nbsp;First SyntaxWith this syntax the row context can be apply normaly, a different value for every Agency.If I use another formula, the value is good (3,70 TOTAL), but there is no several values with the agency contextWhy ??Thank a lot.&nbsp;

Forum Discussion

Problem with CALCULATE, lost the filter context

2 Replies

Related content

Problem with calcul

DAX total vs row context problem

Calculation problem

Problem with filter context

Logic problem?