Forum Discussion

RajaCSN's avatar
RajaCSN
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Need help on creating a Dax Formula

Hi All,   I have a situation as below:   My company sells a SET of four items, say SET_ABCD.  The set will contain Individual products A,B,C, and D. We also sell the product A,B,C,D as individua...
  • amitchandak's avatar
    amitchandak
    4 years ago

    RajaCSN , Only use final product in visual

     

    First measure 
Qty = SUM(Data[QtySold]) 

final measure

Measure = sumx(SUMMARIZE('Product','Product'[Product],'Product'[Final Product], "_Sum", [Qty]),[_sum])
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

RajaCSN , Only use final product in visual

 

First measure 
Qty = SUM(Data[QtySold]) 

final measure

Measure = sumx(SUMMARIZE('Product','Product'[Product],'Product'[Final Product], "_Sum", [Qty]),[_sum])
RajaCSN's avatar
RajaCSN
Icon for Advocate II rankAdvocate II
4 years ago

Thank you so much Amit.  This works like a charm! (BTW, I am now able to understand how the SUMMARIZE function can be used in similar scenarios!)