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

[Marc_S]

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.

[TomMartens]

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

[Marc_S · Accepted solution]

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])))