Accumulated Sum using no date

[yugofukuda]

Hi, I would like to create a formula which accumulates measure using no date (Age).

Could you please teach me how to do that?? 

[yugofukuda]

Hi, does somebody help me out...??

[v-kelly-msft · Accepted solution]

Hi @yugofukuda ,

Create a measure as below:

Measure = SUMX(FILTER(ALLSELECTED('sample'[Age]),'sample'[Age]<=MAX('sample'[Age])),[DIf])

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[yugofukuda]

@v-kelly-msft 

Thank you very much!! It worked well.

[amitchandak]

@yugofukuda , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Can you please try like this. Assumed Age is a column

//Age is in a different table

Cumm Measure= CALCULATE([Measure],filter(Age,Age[Age] <=max(date[date])))

//Age is in the same table

Cumm Measure= CALCULATE([Measure],filter(Allselected(Table),Table[Age] <=max(Table[date])))

//Accumulated  only in Grand total

if(isfiltered(Table[Month]), [Measure],[Cumm Measure])

[yugofukuda]

@amitchandak

Thank you for your support!! 

https://app.box.com/s/om3qsw953wd66nhyqp9gv1omcjtk1x2e

This link is for you to download my sample file. Could you please check it when you are free??