Sum and then get the max value

[BigKev]

Hi All,

I have this use case, where I need to sum the value of the Category, and then show the max value. Does anyone know how I can achieve this using the calculated measure?

This is my data Set

Category	Product	Value
A	Book	1
A	Furniture	2
B	Book	3
B	Furniture	4
C	Book	5
C	Furniture	6

Initially, I would need to sum all value by category. The result should look like this

Category	Value
A	3
B	7
C	11

And then I need to show the value of "11" as a KPI, as it is the max value of all categories. 

Please help.

Cheers,

Kev

[Ashish_Mathur]

Hi,

Write these measures

Total = SUM(Data[Value])

Max of total = MAXX(VALUES(Data[Category]),[Total])

Drag Max of total to your vosual.

[BigKev]

Hey  Ashish,

Thanks for the prompt reply.

I have tried the dax measure that you have provided. However, it give me the total values for all category instead. In this case it is "21". Am I missing anything?

Cheers,

Kev

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

Hope this helps.