Forum Discussion
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 colu...
- 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])))
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])))
test = AVERAGEX(Values(CurrentDateTable[WIPAvgDev]), CALCULATE(AVERAGE(CurrentDateTable[WIPDev2])))