Forum Discussion

arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
3 years ago

Average on selected Value

Hi,     Need to calcuate Average on selected Value. Product Style No Sale Qty Avg Sales Qty Sales Qty/ Avg Sales Qty CD SET 1 30 6.26 4.79 CD SET 2 28 6.26 4.47 CD SET ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

arvindarvind24 
How are table1 and Table2 connected? Are looking for a measure or a calculated column?

arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
3 years ago

tamerj1 There are connected through the icode relationship and am looking for measure.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    arvindarvind24 
    What kind of relationship? Which filters which?

    • arvindarvind24's avatar
      arvindarvind24
      Icon for Helper II rankHelper II
      3 years ago

      tamerj1 One to Many relationship with single filter of product.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    arvindarvind24 
    However, please try

    Avg Sales Qty =
CALCULATE (
    AVERAGE ( Table2[Sales Qty] ),
    ALLEXCEPT ( Table1, Table1[Produvt] )
)