Forum Discussion

danielbacher's avatar
danielbacher
Frequent Visitor
4 years ago
Solved

Average contribution margin per hour in table

Hi.
I am trying to get my table to show the average contribution margin pr. hour for each of my employees, but it shows as a sum instead. 



I have a reference report that shows this correctly, that i'm using the same measure from, but i can't seem to figure out why my table shows it differently. 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    danielbacher , You need a measure like

    example

    AverageX(Sumamrize(Table, Table[Emp Id], Table[Date], Table[Hour], "_1", Sum(Table[Margin])), [_1])

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    danielbacher , You need a measure like

    example

    AverageX(Sumamrize(Table, Table[Emp Id], Table[Date], Table[Hour], "_1", Sum(Table[Margin])), [_1])