Forum Discussion

mamunxv8's avatar
mamunxv8
Helper I
2 years ago
Solved

Show unique value and sum quantity

Hi,

 

I have two columns. one is "product name" and the other one is "Remaining quantity". this "product name" has different unique cells and  "Remaining quantity" contains different. I want to show the "product name" once and want to add the Remaining quantity.  I attached an image for better clarification

 

 

The product name table "Anti-Theft Durable Laptop Backpack" shows 3 times and different quantities. I want to show "Anti-Theft Durable Laptop Backpack" once and do the sum of the remaining quantity.

 

How can I do that?

 

Thanks

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    One of ways is to create Product Dimension Table, and use the column name from the dimension table in the visualization.

     

     

     

     

     

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi,

    One of ways is to create Product Dimension Table, and use the column name from the dimension table in the visualization.

     

     

     

     

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      2 years ago

      Hi,

      It is difficult for me to understand without your sample pbix file.

      Do you mean something like below?

       

       

      expected result measure: = 
CALCULATE (
    SUM ( Data[Remaining Quantity] ),
    ALLEXCEPT ( Data, Data[Product Name] )
)