cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sharpedogs
Advocate II
Advocate II

Capturing the Max Value in column

I am trying to capture the Max value in a column for the day. A Peak value if you will....

 

I wnat to call out that the Citrix Max is 36 and RAS is 23. 

 

I need to add a filter in the DAX to seperate both. For some reason i try to use MAXX and i just can't get the right numbers to appear.

 

Time 

Service # of Incidents
2:00pmRAS14
2:30pmCitrix 36
3:00pmRAS23
3:30pmRAS17
4:00pmCitrix 22

 

 

 

5 REPLIES 5
az38
Super User
Super User

Hi @sharpedogs 

maybe this simple measure will be enough?

Measure = CALCULATE(MAX(Table[# of Incidents]), ALLEXCEPT(Table, Table[Service]) )

or

Measure = CALCULATE(MAXX(Table, Table[# of Incidents]), ALLEXCEPT(Table, Table[Service]) )

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Hey, 

Your funtion works great... but I now seeing how I phrased the question it was terrbile...lol.. My issue is that i need a MAX but with a time filter and thats where i am having trouble.

 

Below is a better view of the data i have. I have a time field thats set in 5 minute intervales (starting at 6am to 5pm). I need to report on the Peak Sumed values for each time period. For example, based on the below chart i would want to show in a Card format the MAX value 150. Because at 12:10 PM the service had a total of 150 users and that was larger than the sum values for 12:05pm or 12:15pm. 

 

I struggle with manipulating time intervals.  

 

TimeValueService 
12:05:00 PM10Citrix
12:05:00 PM30Citrix 
12:05:00 PM20Citrix
12:10:00 PM50Citrix
12:10:00 PM50Citrix
12:10:00 PM50Citrix
2:15:00: PM10Citrix
2:15:00: PM10Citrix
2:15:00: PM10Citrix

 

@sharpedogs 

add to ALLEXCEPT Time column like

Measure = CALCULATE(MAXX(Table, Table[# of Incidents]), ALLEXCEPT(Table, Table[Service], Table[Time]) )

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Hey.. I'm going crazy with this calculation as it should be stright forward but I'm not grasping it. 

 

You above DAX is almost spot on. I've been messing with different variations of it to work but i keep running into the same issue. The Max number that comes back is based on the single line NetScaler ID and not the Service name. Below is a deeper view of my dataset. The Service is made up of individuale NetScalers so when it gives the MAX value it gives the single line value tied to the service. I want it to SUM up the values then give back the MAXX of the summed values. 

 

i've tried a 100 different ways of using SUM in the Calcualte MAXX but i can't get it to work.

 

Can you take one last stabe at it for me?

 

TimeNetScalerValueService 
12:05:00 PM12.345.6510Citrix
12:05:00 PM12.445.7730VPN
12:05:00 PM34.667.9920Citrix
12:10:00 PM12.345.6550Citrix
12:10:00 PM12.445.7750VPN
12:10:00 PM34.667.9950Citrix
2:15:00: PM12.345.6510Citrix
2:15:00: PM12.445.7710VPN
2:15:00: PM34.667.9910Citrix

@sharpedogs 

how should look desired output based on your data sample?

if I understand you correct this measure may help you

Measure = 
CALCULATE(MAXX('Table', 
CALCULATE(SUM('Table'[Value]), ALLEXCEPT('Table', 'Table'[Time], 'Table'[Service]))), 
ALLEXCEPT('Table', 'Table'[Time])
)

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors