Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
Hi,
I finally solved it by the following measure:
Employee Cost = CALCULATE( SUM('Table'[Cost]), FILTER( ALL('Table'), 'Table'[Date] = MAX('Table'[Date]) ) )