Forum Discussion

NDG's avatar
NDG
Frequent Visitor
4 years ago
Solved

Create average measure

Good day,          How to calculate average using measure (data source is restricted to add calculated columns) on the measure from one table that will depend on two columns from two different tabl...
Show and Tell
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, NDG 

    Try this:

    Measure2 =
AVERAGEX(
    FILTER(
        ALL( 'Table (2)' ),
        [Manufacturing Plant] = MAX( 'Table (2)'[Manufacturing Plant] )
    ),
    [_Req Ship - Sched Ship]
)

    [_Req Ship - Sched Ship] is a measure now.

    _Req Ship - Sched Ship = SUM('Table (2)'[Req Ship - Sched Ship])

     

    Result:

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

NDG's avatar
NDG
Frequent Visitor
4 years ago

smpa01 we have 3 different tables where table Ship Date column Requested Ship minus Scheduled Ship date is measure (delta between Scheduled Ship Date and requested ship date). Now, when I need a measure to have an average on this delta that will depend on the Plant and Product Category (2 different tables). 

So 2 plants A and B, different product category where we can have same one at the 2 plants and the delta in days,