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])
Anonymous I suggest transforming such a 2-dimensional into a 1-dimensional table in the first place, so that a versatile measure can be authored instead of specific Data1, Data2, ...
Measure = AVERAGEX ( DISTINCT ( DS ), DS[Value] )
That probably would simplify things (a simpler table). Thanks!