pull the minimum and maximum value

[Anonymous]

Dear all,

I need to create two measures to retrieve the minimum and maximum value and add it to the visual below.

As I use the slicer to filter Area, the visual should dynamically pull the minimum and maximum monthly values.

As an example, I want the minimum measure to be 386,172.62 and the maximum to be 1,166321.67.

[amitchandak · Accepted solution]

@Deevs_411470 ,

Suppose you have measured actual sales

calculate(minx(values(Table[Month]), [Real Sales]), allselected())

calculate(maxx(values(Table[Month]), [Real Sales]), allselected())

[VahidDM]

Hi @Anonymous 

Try these measures:

Maximum =
CALCULATE ( MAX ( [Actual Sales] ), REMOVEFILTERS ( table[Month Name] ) )

Minimum =
CALCULATE ( MIN ( [Actual Sales] ), REMOVEFILTERS ( table[Month Name] ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Anonymous]

@VahidDM 

I don't think that measure is working 

[amitchandak · Accepted solution]

@Deevs_411470 ,

Suppose you have measured actual sales

calculate(minx(values(Table[Month]), [Real Sales]), allselected())

calculate(maxx(values(Table[Month]), [Real Sales]), allselected())

[Anonymous · Accepted solution]

@amitchandak 

Legend 🙂