Forum Discussion
Average counting each instance in a group only once
I'm trying to create a column with an average for each Name, but the formula should only factor in each unique Code instance one time. Here is the data below with expected output on the right. F...
johnt75
Super User
Super UserYou can create a measure like
Distinct average =
AVERAGEX(
SUMMARIZE( 'Table', 'Table'[Code], 'Table'[Value] ),
'Table'[Value]
)
Unfortunately this formula does not work, that generates an average for the whole table, it does not generate an average within each Name
- johnt75
It should do if you put it in a visual with the Name column