SUM Cost per day

[EsterBR]

Hi.

I have the following with different dates: 

I would like to sum the cost per day of the employee, but without taking into account the date. I would like that independently of the date selected the sum of the cost show only the cost per day, not the sum of the cost per day.

I would like to see this table:

And this table:

Instead of this that it is the sum of the cost per day of all the days per email.

How can I achieve this?

Thanks!

[v-nuoc-msft · Accepted solution]

Hi @EsterBR

If you want to sum up by date and team per day, try it:

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

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[EsterBR]

@v-nuoc-msft It works, Thanks a million!

[ryan_mayu]

@EsterBR 

not clear about the request. 

if you don't want to sum by day,  then do not add the date column to the visual

if this does not solve your problem, pls paste the sample data here(not the screenshot) and the expected output based on the sample data you provided.