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 , Your product dimension should be like this. You will join with your table on product M-M join and use final product in display

 

Product Final Product
A A
B B
C C
D D
SET_ABCD A
SET_ABCD B
SET_ABCD C
SET_ABCD D