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!

5 Replies

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