That cumulative sum graph does not show value if it does not correspond

[Syndicate_Admin]

Good morning, I need to make a daily sales sum graph of the current month compared to the previous year, but I need you to only show me until the current day of the current month and not repeat the value of the sum until the last day.

This is the code I use.

Spoiler

Cumulative 2022 = CALCULATE([TOTAL my 2022],

FILTER(ALLSELECTED('412 - DIARIES'),'412 - DIA'[DIA] <= MAX('412 - DIA'[DIA]

)))

[MFelix]

Hi @Anonymous ,

Try to use the following measure:

Cumulative 2022 =
CALCULATE (
    [TOTAL my 2022],
    FILTER (
        ALLSELECTED ( '412 - DIARIES' ),
        '412 - DIA'[DIA] <= MIN ( TODAY (), MAX ( '412 - DIA'[DIA] ) )
    )
)

[Syndicate_Admin]

Thanks for the reply, it appears the same way using that code.

[MFelix]

Hi @Anonymous ,

You want the value to be blank when is higher than today is that it?

Try the following code:

Cumulative 2022 =
IF (
    SELECTEDVALUE ( '412 - DIA'[DIA] ) <= TODAY (),
    CALCULATE (
        [TOTAL my 2022],
        FILTER (
            ALLSELECTED ( '412 - DIARIES' ),
            '412 - DIA'[DIA] <= MAX ( '412 - DIA'[DIA] )
        )
    )
)