Forum Discussion

Humberto_Junior's avatar
Humberto_Junior
New Member
2 years ago
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...
Need Help
Tutorial Requests
  • sayaliredij's avatar
    sayaliredij
    2 years ago

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

sayaliredij's avatar
sayaliredij
Solution Sage
2 years ago

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's avatar
    Humberto_Junior
    New Member
    2 years ago

    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?