Forum Discussion

oneillp111's avatar
oneillp111
Frequent Visitor
5 years ago

Cumulative matrix measure

I am trying to create a measure that will do a cumulative total within the matrix.  Below is a snipit of the data, the  The measure would give me the sum of the value and the value before ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

oneillp111 , try like


Running MQ Sum = CALCULATE(sum('Data'[sum MQ]),filter('Data','Data'[fail MQ]<=max('Data'[fail MQ])))

or

Running MQ Sum = CALCULATE(sum('Data'[sum MQ]),filter(allselected('Data'),'Data'[fail MQ]<=max('Data'[fail MQ]) && 'Data'[Helper2] =max('Data'[Helper2])))