Display the MAX value for each model

[Humberto_Junior]

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 that?

[sayaliredij]

Hi @Humberto_Junior 

Its just measure name for maximum capacity

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

[Humberto_Junior]

Hey, @sayaliredij !

Sorry for the delay, I was on vacation. So, I tried here and I haven't succeeded here yet. 😪
How do I share the .pbix with you?

[sayaliredij · Accepted solution]

HI @Humberto_Junior 

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!! 

[Humberto_Junior]

THANKS!!!

Finally I did it!

DAX: 

MAX CAPACIDADE CADA MODELO = MAXX(SUMMARIZE('Demonstrativos RICOH', 'Demonstrativos RICOH'[MODELO], "MAX CAPACIDADE VOLUME", MAX('Impressoras GAB'[CAPACIDADE VOLUME (VIDA ÚTIL)])), [MAX CAPACIDADE VOLUME])

[Humberto_Junior]

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