Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Weighted AVG DAX calculation

Hi All -    This is basically where i pick the fields needed from two tables.    My error is coming from the "Sheet1" table where it flags the field with red line. On looking up the meaning of th...
i need help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Anonymous 

    In your example, which one is table sheet1? Also please confirm that the relationship is one to many single way

  • tamerj1's avatar
    tamerj1
    3 years ago

    Anonymous 

    Please try

     

     

     

    Weighted Avg =
VAR T1 =
    RELATEDTABLE ( Sheet2 )
VAR T2 =
    FILTER ( T1, Sheet2[Market_Price] <> BLANK () && Sheet2[HAS_Analytics] = 1 )
RETURN
    SUMX (
        T2,
        DIVIDE ( Sheet2[Market_Value] * Sheet2[Market_Price], Sheet2[Market_Value] )
    )

     

     

     

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

Hi Anonymous 

Please try

Weighted Avg =
VAR T1 =
    ADDCOLUMNS ( Sheet2, "@MarketPrice", RELATED ( Sheet1[Market_Price] ) )
VAR T2 =
    FILTER ( T1, [HAS_Analytics] = 1 && [@MarketPrice] <> BLANK () )
RETURN
    DIVIDE (
        SUMX ( T2, [Market_Value] * [@MarketPrice] ),
        SUMX ( T2, [Market_Value] )
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Tamerj - Thank you for the response. I'm still getting the same error on [Market_Price]

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

      Anonymous 

      what is the relationship between the two tables?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Tamerj-