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
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, oneillp111 

You need to create an index column  in "Transform Data" after sorting by date and MQ in ascending order.

Then please try measure as below:

Measure =
CALCULATE (
    SUM ( Data[sum MQ] ),
    FILTER (
        ALL ( Data ),
        Data[Index] <= MAX ( Data[Index] )
            && Data[Created on] = MAX ( Data[Created on] )
    )
)

Then result will show as below:

 

Please check attached pbix for more detail.

If it doesn't meet your requirement,please share more details.

 

Best Regards,
Community Support Team _ Eason