Sum month for all dates

[Ilse_ScpDt]

Dear platform,

I have a measure that is always showing the MAX value. So if you group the days to a week you won't get 2+3+2+3+2 but you get the Max (in this case not 12 but 99). 

I made the following (easy) measure to get the wanted 12:

PM_Needed_Present_week =

var ma = CALCULATE([PM_Needed_Present],DIM_Calendar[DutchDayName] = "Maandag")

var di = CALCULATE([PM_Needed_Present],DIM_Calendar[DutchDayName] = "Dinsdag")

var wo = CALCULATE([PM_Needed_Present],DIM_Calendar[DutchDayName] = "Woensdag")

var do = CALCULATE([PM_Needed_Present],DIM_Calendar[DutchDayName] = "Donderdag")

var vr = CALCULATE([PM_Needed_Present],DIM_Calendar[DutchDayName] = "Vrijdag")

return

ma + di + wo + do + vr

How do I get the same measure for a month?

[AlexisOlson]

FYI, you can use an iterator to sum over the days:

PM_Needed_Present_week =
VAR _Days =
    FILTER (
        VALUES ( DIM_Calendar[DutchDayName] ),
        DIM_Calendar[DutchDayName] IN { "Maandag", "Dinsdag", "Woensdag", "Donderdag", "Vrijdag" }
    )
RETURN
    SUMX ( _Days, [PM_Needed_Present] )

If you want to sum over all days, then you can just write:

PM_Needed_Present_week =
SUMX (
    VALUES ( DIM_Calendar[DutchDayName] ),
    [PM_Needed_Present]
)

[Ilse_ScpDt]

Thanks a lot! Also something I was looking for.

How would this work for the sum over a month instead of a week?

[AlexisOlson]

Same syntax but replace the day columns with the month column.

For example:

PM_Needed_Present_week =
VAR _Months =
    FILTER (
        VALUES ( DIM_Calendar[DutchMonthName] ),
        DIM_Calendar[DutchMonthName] IN { "mei", "juni", "juli" }
    )
RETURN
    SUMX ( _Months, [PM_Needed_Present] )

[amitchandak]

@Ilse_ScpDt , Assume this is a measure: PM_Needed_Present

A measure like

Maxx(Values(DIM_Calendar[DutchDayName]),[PM_Needed_Present])

[Ilse_ScpDt]

Thanks for the reply.

I am not looking for the maximum value, but trying to sum all values of the seperate days. For the week I can use the measures above. But how would it work for a month?