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 empl...
Need Help
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]) 
    )
)