Issue with Calculated measure

[pranshul]

SnapshotHi Team,

I am facing issue in changing the calculated measure from sum to Max as shown in the screen shot. Could you please suggest an alternative. I have tried converting the same from text to whole number format.

Looking for Reply.

Thanks & Regards

[MattAllington]

A few things. The correct term is “measure”, and you don’t need the “calculated”. All measures are calculated. If you add a column of numbers to a visual, you will have a choice to change the aggregation behaviour between sum, max, min, count etc. You can’t do this with a measure, which is why you can’t see that option. You need to select the measure and edit it (assuming you have power bi desktop.)