Forum Discussion

JMcAnarney1's avatar
JMcAnarney1
Icon for Helper I rankHelper I
3 years ago
Solved

Have Averages add up in Matrix

Question how do I write a formula to where the averages of the unit add up to total in matrix graph for example i have following formula:

Average of Other Bids = Calculate(AVERAGEA('Bid Template Data'[Total Cost]),'Bid Template Data'[Winning Bid] = "No",'Bid Template Data'[Bidder] <> "Engineering Estimate")
 
But I want the averages to add up compared to the picture: As you can see my total should be well above 13k
 

 

 

Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    JMcAnarney1 I think you need this:

     

    Average of Other Bids =
SUMX ( 
   VALUES ( Table[Employee Name] ),
   Calculate ( 
        AVERAGEA( 'Bid Template Data'[Total Cost] ),
        'Bid Template Data'[Winning Bid] = "No",
        'Bid Template Data'[Bidder] <> "Engineering Estimate"
   )
)

     

    Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    JMcAnarney1 I think you need this:

     

    Average of Other Bids =
SUMX ( 
   VALUES ( Table[Employee Name] ),
   Calculate ( 
        AVERAGEA( 'Bid Template Data'[Total Cost] ),
        'Bid Template Data'[Winning Bid] = "No",
        'Bid Template Data'[Bidder] <> "Engineering Estimate"
   )
)

     

    Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!