Forum Discussion

Jaskiratr's avatar
Jaskiratr
Regular Visitor
4 years ago
Solved

Find sum per unique value from another column

Hello! So I have a sales order data set with multiple line items with different values even for the part number, as seen in the picture below.    What I want to do is create a DAX measure th...
Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi, Try this

     

    Value_ Sum(Value)

     

    Place the below measure in a card visual to get what you need.

    Top Part =
    IF (
    NOT ( ISBLANK ( [Value_] ) ),
    MAXX (
    TOPN (
    1,
    SUMMARIZE (
    'Part Table',
    'Part Table'[#Part],
    "Sales Total", [Value_]
    ),
    [Sales Total]
    ),
    'Part Table'[#Part]
    )
    )
     
     
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

You're welcome, it's a very useful pattern to have. You can swap material for customer in summarize and it would give you the top customer by part in a matrix visual.