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

Thanks, v-angzheng-msft, can't use AVERAGE as Req Ship -Scheduled Ship is a measure, power bi doesn't let me.

 

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
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.