Sum of Max data in measure

[Vaishali04]

Hi All,

I need help in  building a logic in DAX.

I have below data.

Key	Circuit	In	Out
A	A1	2	4
A	A2	7	4
B	B1	1	2
B	B2	6	3
B	B3	3	6

I want to build below  table at UI. I can't create calculated  max_in_out column in backend because I am using what if parameter to modify In and out value on user input.What if parameter value can not be used in calculated column. So need to calculate max_in_out and Sum as measure.

Key	Circuit	Max_In_Out	Sum of Max
A	A1	4	11
A	A2	7	11
B	B1	2	14
B	B2	6	14
B	B3	6	14

Thanks & Regards

Vaishali Rathi

[harshnathani]

Hi @Vaishali04 ,

Create a Column

MAX_IN_OUT = IF('Table'[In] >='Table'[Out] , 'Table'[In] , 'Table'[Out])

Create a measure

Measure = SUMX(FILTER(ALL('Table'),'Table'[Key] = MAX('Table'[Key])),'Table'[MAX_IN_OUT])

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani · Accepted solution]

Hi @Vaishali04 ,

Incase you donot want to create a column

Create 2 measures

MAX_IN_OUT Meausre = IF(MAX('Table'[In]) >= MAX('Table'[Out]) , MAX('Table'[In]) , MAX('Table'[Out]))

Sum of Max = SUMX(FILTER(ALL('Table'),'Table'[Key] = MAX('Table'[Key])),[MAX_IN_OUT Meausre])

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)