Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost Patron
6 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
    6 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.

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost Patron
6 years ago

Hi,

 

both did not work

 

  • abukapsoun's avatar
    abukapsoun
    Icon for Post Patron rankPost Patron
    6 years ago

    I am expecting (350+400+600)/3