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