Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

pull the minimum and maximum value

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.image.png

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Deevs_411470 ,

Suppose you have measured actual sales

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

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

View solution in original post

Anonymous
Not applicable

4 REPLIES 4
VahidDM
Super User
Super User

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
Not applicable

@VahidDM 

 

I don't think that measure is working 

 

Deevs_411470_0-1634709847731.png

 

amitchandak
Super User
Super User

@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
Not applicable

@amitchandak 

Legend 🙂

Deevs_411470_0-1634702170758.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.