Forum Discussion

Marc_S's avatar
Marc_S
Regular Visitor
7 years ago
Solved

Help Measure designed to average a column based on the distinct values is not working

test = CALCULATE(AVERAGE(CurrentDateTable[WIPDev2]),VALUES(CurrentDateTable[WIPAvgDev]))

The goal is to take  the WIPDev2 column and average it only when there is a unique value in WIPAvgDev column.
 
This does not work however so im not sure where i went wrong.
Need Help
  • Marc_S's avatar
    Marc_S
    7 years ago
    I did a bit of searching and found my answer Ill leave it up for others

    test = AVERAGEX(Values(CurrentDateTable[WIPAvgDev]), CALCULATE(AVERAGE(CurrentDateTable[WIPDev2])))

2 Replies

  • Marc_S's avatar
    Marc_S
    Regular Visitor
    7 years ago
    I did a bit of searching and found my answer Ill leave it up for others

    test = AVERAGEX(Values(CurrentDateTable[WIPAvgDev]), CALCULATE(AVERAGE(CurrentDateTable[WIPDev2])))
  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    I guess this measure will do what you want:

    test = 
var theValues = VALUES(CurrentDateTable[WIPAvgDev]
var NoOfValues = COUNTROWS(theValues)
return
DIVIDE(
SUMX(
    theVALUES
    , CALCULATE(AVERAGE(CurrentDateTable[WIPDev2]))
)
, NoOfValues
)

    Hopefully this is what you are looking for.

     

    Regards,
    Tom