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 ...
arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
3 years ago

FYI.

Table1Table1Table1Table1Table2Based on Product I need the Avg (Result Required)
ProductSizeStyle NoColourSale QtyAvg Sales Qty
Product01S1Red3012.63
Product01M2Black2812.63
Product01XL3Green1412.63
Product01XXL4Red1312.63
Product01S5Black1112.63
Product01M6Green912.63
Product01XL7Red812.63
Product01XXL8Black712.63
Product01S9Green712.63
Product01M10Red612.63
Product01XL11Black612.63
Product02S12Green53.83
Product02M13Red53.83
Product02XL14Black43.83
Product02XXL15Green43.83
Product02S16Red43.83
Product02M17Black43.83
Product02XL18Green43.83
Product02XXL19Red43.83
Product02S20Black33.83
Product02M21Green33.83
Product02XL22Red33.83
Product02S23Black33.83
Product03XL24Green32.54
Product03XXL25Red32.54
Product03S26Black32.54
Product03M27Green32.54
Product03XL28Red32.54
Product03XXL29Black32.54
Product03S30Green22.54
Product03M31Red22.54
Product03XL32Black22.54
Product03M33Green22.54
Product03M34Red22.54
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] )
)