Forum Discussion

dino19547's avatar
dino19547
Regular Visitor
4 years ago
Solved

Subtotal not Matching Detailed Items

 Hi PBI community,   I am having issues with subtotals not adding up to total items in a category in a matrix.   My goal is to get the quantities sold for a Product.   For this I need to multip...
  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    4 years ago

    Hi dino19547 ,

     

    Try using following measure:

     

     

     

    Qty Sold2 = SUMX(VALUES('Table (3)'[SKU]),(CALCULATE(SUM('Table (3)'[Qty Sold])* SUM('Table (2)'[Quantity in Carton]))))
     
     
    Mark this as a solution, if I answered your question. Kudos are always appreciated.
    Thanks

     

dino19547's avatar
dino19547
Regular Visitor
4 years ago

Hi Tanushree, may I ask - why does your solution work with Values(Table[SKU] and not with Values(Table[Cheese Type] under this filter context? Sorry this is a burning question I have!