Forum Discussion

yugofukuda's avatar
yugofukuda
Helper IV
5 years ago
Solved

Accumulated Sum using no date

Hi, I would like to create a formula which accumulates measure using no date (Age). Could you please teach me how to do that?? 
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!
amitchandak's avatar
amitchandak
Super User
5 years ago

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])