Need help with 'Total on a card incorrect'

[Anonymous]

Hi Community,

I am stuck at a problem that might be something very simple to resolve, but I can't find a resolution.

So I have a measure that calculates totals. If I pull this measure on a card I get incorrect total, but on a line graph the measure displays correct values & when summed gives correct total. 

Also I get wrong cumulative totals.

Can someone please help me figure out whats going on here?

Here is my sample pbi:  https://1drv.ms/u/s!Ag919_pO_UKrgQ_cQ8o4TbfZsWBJ?e=ioNd6f

Many thanks!

[amitchandak]

@Anonymous , Try a measure like

Cumulative_total = CALCULATE([Totals],FILTER(ALL(Datedim),Datedim[Date] <= MAX(Datedim[Date]) ))

Or

Cumulative_total = var _max = maxx(ALLSELECTED(w_test), w_test[Case_OPENED_ON])
return if(max(Datedim[Date]) <=_max , CALCULATE([Totals],FILTER(ALL(Datedim),Datedim[Date] <= MAX(Datedim[Date]) )),BLANK())

[Anonymous]

@amitchandak thanks, but the measure suggested by you doesn't work. Gives the same result 300. 

Any suggestion on the card?

[amitchandak · Accepted solution]

@Anonymous , You need use month year from date visual with this measure

Cumulative_total = CALCULATE(sumx(values(Datedim[Month_year]),[Totals]),FILTER(ALL(Datedim),Datedim[Date] <= MAX(Datedim[Date]) ))

file attached after signature