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 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.
I am expecting (350+400+600)/3
abukapsoun ,Please find the attached file after the signature . I think that 450 . refer Avg2, Avg 3
- Still not working 😞
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.