Forum Discussion
RajaCSN
Advocate II
Advocate IINeed 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...
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])
RajaCSNAdvocate II
Advocate IIHi Amit,
Your solution is really cool. My bad, I tried with some complex logic here and there and you had just given me the "magic spell".
Since the Quantity Sold values are picked from the invoice table, the total value is not reflecting the expected total.
This being a Many-to-Many model, that's how it should happen. Is that right? Or is there a way around to get the total values too, as expected? (Timebeing, I can switch off the TOTAL and use this table).
Many thanks.
amitchandak
Super User
Super UserRajaCSN , 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
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!)