Burndown for the current month

[E_K_]

I'm so stuck - read lots of articles and forum posts on here but nothing advised that I try is working. Please help!

I am trying to create a burndown for this month. For this I need only 2 datasets 'Dates' (my connected dimdate table) and 'Incidents (NO SPLITS)'.

I have a measure for target (that is based on a KPI) here: 

Target Month Incidents =

VAR currentDate = TODAY()

VAR star = STARTOFMONTH('Dates'[Date])

VAR enh = ENDOFMONTH('Dates'[Date])

VAR calc = DIVIDE(0.8 * [Incident Volume YE last year], 12, 0)

RETURN

        CALCULATE(

            calc,

            FILTER(

                ALL('Dates'), // Ignore any filters that might limit the Dates context

                'Dates'[Date] >= star && 'Dates'[Date] <= enh

            )

        )

I have a target for the accumulation which is based off of a column in 'Incidents (NO SPLITS)' which shows a 1 for if the incident is in the current month and a 0 if not. 

Cumulative month incidents =

VAR currentDate = TODAY()

VAR star = STARTOFMONTH('Dates'[Date])

VAR enh = ENDOFMONTH('Dates'[Date])

VAR calc =  CALCULATE(SUM('Incidents (NO SPLITS)'[InCurrentMonth]))

RETURN

        CALCULATE(

            calc,

            FILTER(

                ALL('Dates'), // Ignore any filters that might limit the Dates context

                'Dates'[Date] >= star && 'Dates'[Date] <= enh

            )

        )

Lastly, my burndown measure just 

Incitndet monthly burndown =

[Target Month Incidents] - [Cumulative month incidents]

The values show okay in a table or graph if I don't add a date to the axis, however when I do it shows Target as 0, the cumulative measure as just adding the number per day (rather than + on the previous day) and the burndown as negative values (as the target is 0). 
I've tried all sorts, using the date from my 'Dates' dataset, the date from my 'Incidents (NO SPLITS)' dataset, a calculated table that just shows the days of March, etc but its not showing correctly. 

What am I doing wrong?

Date added:                                                                                No date:

No date:

[E_K_]

These did not help, thanks for trying, I had already tried that

[v-rongtiep-msft · Accepted solution]

Hi @E_K_ ,

Please have a try.

Cumulative Month Incidents = 
CALCULATE(
    SUM('Incidents (NO SPLITS)'[InCurrentMonth]),
    FILTER(
        ALLSELECTED('Dates'),
        'Dates'[Date] <= MAX('Dates'[Date])
    )
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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