How to add Number Formatting Expression in Measure?

[ishansjain2095]

Hi,

I am trying to use this expression -> "max(aggr(sum(Sales),Property ))" to find out top sale with that property but facing is problem with number formatting which isn't working due to aggr function I assume.

Can anyone help me with expression.

Regards,

ISJ

[inspari_dfg]

You can use this:

Num(max(aggr(sum(Sales),Property )),'#.##0')

for at format like this: 2.000.000

But you should still be able to use the standard number formatting option under the measure

[ishansjain2095]

Trying to use  this expression-> FirstSortedValue(Property,-AGGR(count( Property),Property)) which is not showing Top sale value name... Can you help!!!

[ishansjain2095]

Can I use this-> Num(max(aggr(sum(Sales),Property )),'#.##0') without sum to get top value.....