Forum Discussion

aavilap's avatar
aavilap
Icon for Helper I rankHelper I
8 years ago
Solved

Cummulative Total of Measure

Hello!  Hope someone can help me with this I have been trying to create a measure that adds the monthly result of another calculated measure which uses COUNTROWS but I'm not being able to get the de...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    8 years ago

    Create two measures:

     

    Distinct Customers = DISTINCTCOUNT('Sample'[Customer])

Cummulative Customers = 
    SUMX(
    FILTER(ALL('Sample'[Date]), 'Sample'[Date] <= MAX('Sample'[Date])),
    [Distinct Customers]
    )

    Drop date, and these two measures in a table and you have it.

     

     

aavilap's avatar
aavilap
Icon for Helper I rankHelper I
8 years ago

parry2k Sure, I've created a sample PBIX showing the issue, in the following link: PBIX & Data Sample 

It's a one drive link, this will not show the numbers I had in the example because I was using my real data, would share it but it has a lot of measures and they are not named as in the example, I'm afraid it would be easy to get lost :s

 

Please let me know if you find a way ! thanks!!

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Is this what you are looking for :

 

  • aavilap's avatar
    aavilap
    Icon for Helper I rankHelper I
    8 years ago

    parry2k Yes that would be it!

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      Create two measures:

       

      Distinct Customers = DISTINCTCOUNT('Sample'[Customer])

Cummulative Customers = 
      SUMX(
      FILTER(ALL('Sample'[Date]), 'Sample'[Date] <= MAX('Sample'[Date])),
      [Distinct Customers]
      )

      Drop date, and these two measures in a table and you have it.

       

       

      • aavilap's avatar
        aavilap
        Icon for Helper I rankHelper I
        8 years ago

        Thanks!