power bi average distinct only code example Example: power bi average distinct only AVERAGEX(VALUES(Table[Employee]), CALCULATE(AVERAGE(Table[Age])))