Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
5 years ago
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 t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

abukapsoun , Try a measure like

averageX(values(Table[HC]), max(Table[Price]))

or

averageX(Summarize(Table, Table[HC],"_1", max(Table[Price])), [_1])

abukapsoun's avatar
abukapsoun
Post Patron
5 years ago

Hi,

 

both did not work