Forum Discussion

Loic_Pedro_Hans's avatar
Loic_Pedro_Hans
Regular Visitor
3 years ago

Problem with CALCULATE, lost the filter context

Hi,   This formula is good : Avg Delivery Days =  AVERAGEX (     FILTER (         Delivery_Dte_Fioul_Particuliers,         NOT (Delivery_Dte_Fioul_Particuliers[AGC_LIBC] IN {"x-VDSN","T-PSE Si...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Loic_Pedro_Hans ,

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", "" }
    )
)

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.