Blank Values In Cumulative Chart

[Anonymous]

Is there any way I can make the cumulative values appear when there is no data in the cumulative chart? I have a chart that shows the cumulative values for all the days in the month. Also, I have a date table related to the main table (TAB_CONSOLIDADA_GERAL) which provides all the dates. I want the value of the previous day to be shown when there is no data.

My current measure is as follows:

Cumulative_Total =

VAR vDateContext = MAX(TAB_CONSOLIDADA_GERAL[DTA_INIC_MNB])

RETURN

CALCULATE(

SUM(TAB_CONSOLIDADA_GERAL[TOTAL]),

FILTER(

ALLSELECTED(TAB_CONSOLIDADA_GERAL),

TAB_CONSOLIDADA_GERAL[DTA_INIC_MNB] <= vDateContext

)

)

[Anonymous]

Thank you. That works

[amitchandak · Accepted solution]

@Anonymous , Please use date table in formula and axis

CALCULATE(

SUM(TAB_CONSOLIDADA_GERAL[TOTAL]),

FILTER(

ALLSELECTED(date),

date[date] <= max(date[date])

)

)

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[sam_gift]

Hi, I have similar problem, when I use the above dax, I get all the totals.

Any idea how to resolve it sir?