Forum Discussion

EsterBR's avatar
EsterBR
Helper II
2 years ago

Total Cost

Hi,

 

I have the following table:

I have the following formula to get the sum the cost per day of the employee without taking into account the date. It is to say if a cost per day of an employee is 104,32 the sum of his cost will be always 104,32 and NOT the sum of his cost per day for all the year (104,32*365).

Employee Cost  = 
CALCULATE(
    SUM('Table'[Cost]), 
    FILTER(
        ALL('Table'), 
        'Table'[Date] = MAX('Table'[Date]) 
        && 
        'Table'[Team] = MAX('Table'[Team])
    )
)

So the result is the following:

I am trying to sum the total cost of the Employee Cost , but the result is not correct.

Employee Cost Total = (CALCULATE([Employee Cost ],ALL()))
 
How can I achieve this?
 
Thanks!

 

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi EsterBR 

     

    Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

     

     

     

     

    Best Regards,

    Jayleny

    • EsterBR's avatar
      EsterBR
      Helper II
      2 years ago

      Hi,

       

      I finally solved it by the following measure:

       

      Employee Cost  = 
CALCULATE(
    SUM('Table'[Cost]), 
    FILTER(
        ALL('Table'), 
        'Table'[Date] = MAX('Table'[Date]) 
    )
)