Forum Discussion
Distinct average by two categories
Hello. (sorry for the earlier incomplete post). I am new to power BI. I would like a measure to do a Distinct Average of a column using two (or more) categories for grouping. ID DATE ...
I tried the 2nd suggestion, it worked. Thanks!
To add a 3rd group_by category, just add it to the summarize table?
averageX(summarize(Table, Table[ID], Table[DATE],Table[Type],"_1", max(Table[Data1])),[_1])
Sorry. See edited post above...I tried to clarify why I need distinct average...
Anonymous , Try as a new measure
averageX(values(Table[Type]), max(Table[Data1]))
or
averageX(summarize(Table,Table[DATE],Table[Type],"_1", max(Table[Data1])),[_1])
I tried the 2nd suggestion, it worked. Thanks!
To add a 3rd group_by category, just add it to the summarize table?
averageX(summarize(Table, Table[ID], Table[DATE],Table[Type],"_1", max(Table[Data1])),[_1])