Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure Total

I have a measure "x" that calculates a cumulative of sorts. I want the total to show the value of the last month I am showing in a table, instead of a sum of all (because it is a cumulative). I know ...
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi Anonymous ,

 

If you want to display the maximum month measure value in TOTAL, we can create a measure to meet your requirement.

 

Measure 2 = 
var _maxdate = CALCULATE(MAX('Table'[Year&month]),ALLSELECTED('Table'))
var _x = [Measure]
var _y = CALCULATE([Measure],FILTER('Table','Table'[Year&month]=_maxdate))
return
IF(ISFILTERED('Table'[Year&month]),_x,_y)

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


BTW, pbix as attached.