Forum Discussion
abukapsoun
Post Patron
Post PatronCalculate 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 t...
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.
abukapsounPost Patron
Post PatronI am expecting (350+400+600)/3
amitchandak
Super User
Super Userabukapsoun ,Please find the attached file after the signature . I think that 450 . refer Avg2, Avg 3
- abukapsounStill not working 😞
- Greg_Deckler
Community Champion
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.
- amitchandak
abukapsoun , what is not working, I can see 450 in card, do you need that at each line ?
Calculate(averageX(Summarize(Table, Table[HC],"_1", max(Table[Price])), [_1]) , all(Table))