Get Max and Minimum

[Anonymous]

Goal: Get Minimum and Maximum value from this table

Product	AcctNbr	ARPU	Min	Max
A	1	500	100	500
A	2	200	100	500
A	3	100	100	500
B	4	50	30	50
B	5	40	30	50
B	6	30	30	50

What I am getting is same values for max and minimum. If I remove AcctNbr I want to be able to get 100 for A (min) and 500 for A (max)

ARPU is a measure field. 

When I use MIN or MAX(ARPU), it says that I can only use it if ARPU is a column field. 

[v-yalanwu-msft]

Hi, @Anonymous ;

You could create a measure.

Min = 
MINX(ALLEXCEPT('Table','Table'[Product]),[ARPU])

Max = MAXX(ALLEXCEPT('Table','Table'[Product]),[ARPU])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ribisht17]

@Anonymous 

Use below DAX

1. 

Max ARPU Per Product = CALCULATE(max(MinMax[ARPU]),ALLEXCEPT(MinMax,MinMax[Product]))

2.

Min ARPU Per Product = CALCULATE(min(MinMax[ARPU]),ALLEXCEPT(MinMax,MinMax[Product]))

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[Anonymous]

This is what I am getting: 

[ribisht17 · Accepted solution]

Have you tried MAXX function here, MAXX function (DAX) - DAX | Microsoft Learn

Ritesh

[Anonymous]

Still not working.

ARPU = measure A + measure B... + measure E

What I am trying to do is Minimum of a measure of a measure