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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Humberto_Junior
New Member

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

 

Humberto_Junior_0-1707160059721.png

Humberto_Junior_1-1707160328927.png

 

Humberto_Junior_3-1707160377105.png

 

 

1 ACCEPTED SOLUTION
sayaliredij
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
sayaliredij
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




THANKS!!!

Finally I did it!

Humberto_Junior_0-1708613996772.png

 

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])

Hey, @sayaliredij !

What's the "MAX_Cap" ??

Humberto_Junior_0-1707162419740.png

Example of data:

SERIALMODELMAX CAPACITY
3080R10IM C2000900000
3082R40IM C2000900000
3082RA0IM C2100800000
3090RC0IM C2500650000

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.