Total Cost

[EsterBR]

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!

[v-jialongy-msft]

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]

Hi,

I finally solved it by the following measure:

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