How to find the max value for a calculated numeric measure?

[TusharGaurav]

Hi Experts,

I have the following table Visual in my report:

Emp Name	Quantity Sold
John	122
Peter	54
Ravi	67
Rakesh	98
Neha	155

Here "Quantity Sold"is a calculated measure.

Now I need to create a new measure to fetch the maximum "Quantity Sold" which is 155 so the table visual will be as below:

Emp Name	Quantity Sold	Max Quantity Sold
John	122	155
Peter	54	155
Ravi	67	155
Rakesh	98	155
Neha	155	155

I cant use calculated column so is there any way I can create a calculated measure to show maximum "Quantity Sold"?

Thanks,

Tushar

[rajendraongole1 · Accepted solution]

Hi @TusharGaurav -You can define a measure that calculates the maximum of your "Quantity Sold" measure across all employees.

you can replace with your table name.

Max Quantity Sold = MAXX(ALL('quant'), [Quantity Sold])

Hope this works

[TusharGaurav · Accepted solution]

Hi Rajendra,

Thanks a lot for your help.

It worked.

Thanks and Regards,

Tushar

[rajendraongole1 · Accepted solution]

Hi @TusharGaurav -You can define a measure that calculates the maximum of your "Quantity Sold" measure across all employees.

you can replace with your table name.

Max Quantity Sold = MAXX(ALL('quant'), [Quantity Sold])

Hope this works