Forum Discussion

cmcgo3's avatar
cmcgo3
Helper II
2 years ago
Solved

Need Cumulative Measure

I am trying to create a new measure that will calculate a cumulative total in either a table or matrix as well as give correct total in a card.  In the attached pbix file the cumulative total for this small dataset should be 3. My verification counter measure has variables.  I understand that the below measure works under normal circumstances but its not calculating accurately.  Any help is appreciated!

 

Cumulative =
CALCULATE([Verification counter],
     FILTER(ALL('Table1'[Day of Week ]),
        'Table1'[Day of Week ] <= MAX('Table1'[Day of Week ])
     )
)

 

 

Cumulative.pbix 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Give this a try:

    Cumulative = var endDate = MAX('Table1'[Day of Week ])
RETURN
CALCULATE(
	[Verification counter],
	ALL('Table1'[Day of Week ]),
	'Table1'[Day of Week ] <= endDate
)
  • cmcgo3's avatar
    cmcgo3
    2 years ago

    THANK YOU BOTH!  This works perfectly!!!  What a great resource this platform is!!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Give this a try:

    Cumulative = var endDate = MAX('Table1'[Day of Week ])
RETURN
CALCULATE(
	[Verification counter],
	ALL('Table1'[Day of Week ]),
	'Table1'[Day of Week ] <= endDate
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, cmcgo3 

    Thanks for Anonymous  reply. You can refer to the following dax to solve the problem.

    Cumulative = 
VAR _table =
    SUMMARIZE (
        'Table1',
        'Table1'[Day of Week ],
        "Verification counter", [Verification counter]
    )
RETURN
    SUMX ( _table, [Verification counter] )


CumulativeVerificationCounter = 
CALCULATE (
    [Cumulative],
    FILTER ( ALL ( Table1 ), Table1[Day of Week ] <= MAX ( Table1[Day of Week ] ) )
)

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

     

    • cmcgo3's avatar
      cmcgo3
      Helper II
      2 years ago

      THANK YOU BOTH!  This works perfectly!!!  What a great resource this platform is!!