Forum Discussion

sobsawats's avatar
sobsawats
Frequent Visitor
9 years ago
Solved

SUM only same product UoM

Hi all, I have transaction of product and its multi level product group, each product line has quantity which I want to sum it to its uppler product group. The condition of sum is if product has sam...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    sobsawats,

     

    You may add measures as follows.

    QTY2 =
IF ( DISTINCTCOUNT ( txn[UNIT] ) = 1, SUM ( txn[QTY] ), 0 )

    UNIT2 =
IF ( DISTINCTCOUNT ( txn[UNIT] ) = 1, MAX ( txn[UNIT] ), "NA" )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
9 years ago

sobsawats,

 

You may add measures as follows.

QTY2 =
IF ( DISTINCTCOUNT ( txn[UNIT] ) = 1, SUM ( txn[QTY] ), 0 )

UNIT2 =
IF ( DISTINCTCOUNT ( txn[UNIT] ) = 1, MAX ( txn[UNIT] ), "NA" )
sobsawats's avatar
sobsawats
Frequent Visitor
9 years ago

v-chuncz-msft

 

Thank you so much. It is easier than I can imagine.