Forum Discussion
Group by a report Column
I have a table
| ID | Item | Cost |
| 1 | A | 100 |
| 1 | B | 200 |
| 1 | C | 300 |
| 2 | A | 200 |
| 2 | B | 200 |
if we say the average cost per item
Average cost : =Average (cost)
now I want to find the maximum average per Item so the output will be
| Item | avg | max avg |
| A | 150 | 200 (which is an average of B) |
| B | 200 | 200 |
| C | 150 | 200 |
how can I write a max avg Equation....
thank you
Anonymous -
You can do as:
Measure = CALCULATE( AVERAGE(TableName[Cost]), REMOVEFILTERS(TableName[Item]) )
1 Reply
Anonymous -
You can do as:
Measure = CALCULATE( AVERAGE(TableName[Cost]), REMOVEFILTERS(TableName[Item]) )