Forum Discussion
Solved
Calculate distinct
Hi,
I need your expertise please
I have the following table
| HC | Price |
| X | 350 |
| X | 350 |
| X | 350 |
| Y | 400 |
| Y | 400 |
| Z | 600 |
| Z | 600 |
How can I compute the average price taking into consideration distinct HCs and not all of them?
Thanks,
abukapsoun - Seems like this should be:
Measure 29 = VAR __Table = SUMMARIZE('Table (29)',[HC],"Average",AVERAGE([Price])) RETURN AVERAGEX(__Table,[Average])Attached PBIX below sig, Page 29.
8 Replies
abukapsoun , Try a measure like
averageX(values(Table[HC]), max(Table[Price]))
or
averageX(Summarize(Table, Table[HC],"_1", max(Table[Price])), [_1])
Hi,
both did not work
