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 sho...
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.

     

     

     

     

     

mamunxv8's avatar
mamunxv8
Helper I
2 years ago

Thanks..can I do it using the Dax function?

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