Forum Discussion
Solved
Display the MAX value for each model
Heey, I wanted to display by graph the max values for each model of printers because each printers have your max capacity to print but actually is showing the one max value of them. How I can do tha...
It would be beneficial to see how your data looks but i would imagine DAX would look like below
Measure =MAXX (SUMMARIZE (Table_name,Table_name[Model],"MAX_Cap", MAX(Table_name[Capacity])),[MAX_Cap])Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
It would be beneficial to see how your data looks but i would imagine DAX would look like below
Measure =
MAXX (
SUMMARIZE (
Table_name,
Table_name[Model],
"MAX_Cap", MAX(Table_name[Capacity])
),
[MAX_Cap]
)
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
Hey, sayaliredij !
What's the "MAX_Cap" ??
Example of data:
| SERIAL | MODEL | MAX CAPACITY |
| 3080R10 | IM C2000 | 900000 |
| 3082R40 | IM C2000 | 900000 |
| 3082RA0 | IM C2100 | 800000 |
| 3090RC0 | IM C2500 | 650000 |