Forum Discussion
Advocate IICapturing 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:00pm | RAS | 14 |
| 2:30pm | Citrix | 36 |
| 3:00pm | RAS | 23 |
| 3:30pm | RAS | 17 |
| 4:00pm | Citrix | 22 |
5 Replies
- az38
Community Champion
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]) )
sharpedogsHey,
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.
Time Value Service 12:05:00 PM 10 Citrix 12:05:00 PM 30 Citrix 12:05:00 PM 20 Citrix 12:10:00 PM 50 Citrix 12:10:00 PM 50 Citrix 12:10:00 PM 50 Citrix 2:15:00: PM 10 Citrix 2:15:00: PM 10 Citrix 2:15:00: PM 10 Citrix - az38
add to ALLEXCEPT Time column like
Measure = CALCULATE(MAXX(Table, Table[# of Incidents]), ALLEXCEPT(Table, Table[Service], Table[Time]) )
