MAX and MIN from a measure

[misaki233]

Hi everyone!

I have a table like the following data.

Column1	Column2	Measure
A	DD	1
B	DD	1
C	DD	1
A	FF	2
B	FF	2

“Measure” is a measure based on column2. Now I want to show min value and max value of each column1. 

Column1	Column2	Measure	expected result(MIN-MAX)
A	DD	1	1-2
B	DD	1	1-2
C	DD	1	1-1
A	FF	2	1-2
B	FF	2	1-2

How can I get the result?

Thank you in advance.

[Anonymous · Accepted solution]

Hi @misaki233 ,

You can create a measure as below:

MIN-MAX = 
VAR _min =
    MINX (
        FILTER ( ALL ( 'Table' ), 'Table'[Column1] = MAX ( 'Table'[Column1] ) ),
        [Measure]
    )
VAR _max =
    MAXX (
        FILTER ( ALL ( 'Table' ), 'Table'[Column1] = MAX ( 'Table'[Column1] ) ),
        [Measure]
    )
RETURN
    CONCATENATE ( CONCATENATE ( _min, "-" ), _max )

Best Regards

Rena

[harshnathani]

Hi @misaki233 ,

Create 3 measures

min measure = CALCULATE(MINX(VALUES('Table'[Column1],[measure]),ALLSELECTED('Table'))

max measure = CALCULATE(MAXX(VALUES('Table'[Column1],[measure]),ALLSELECTED('Table'))

Concatenate measure = CONCATENATE(CONCATENATE([minmeasure], " - "), [max  measure])

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

[amitchandak]

@misaki233 , Try a new measure like

minx(filter(allselected(Table),[Column1]=max([Column1])),[Measure]) -maxx(filter(allselected(Table),[Column1]=max([Column1])),[Measure])