Forum Discussion

ABookbin's avatar
ABookbin
Frequent Visitor
5 years ago
Solved

Averaging using filter

Hi All,  I'm trying to add a column in the table below which provides an average value according to city-city pair. Here's what I have right now. Here are the average values I would like to s...
average
Filter
  • PaulOlding's avatar
    PaulOlding
    5 years ago

    Does this work?

     

    CALCULATE(

    AVERAGE('Air Shipment Tracking'[Actual Transit Days]),

    ALLEXCEPT('Air Shipment Tracking', 'Air Shipment Tracking'[City-City Pair])

    )

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
5 years ago

Does this work?

 

CALCULATE(

AVERAGE('Air Shipment Tracking'[Actual Transit Days]),

ALLEXCEPT('Air Shipment Tracking', 'Air Shipment Tracking'[City-City Pair])

)