Forum Discussion

sajohnson05's avatar
sajohnson05
Frequent Visitor
1 year ago
Solved

Matrix Table not giving the correct total amount

I have created the below meaure that is being implemented in a Matrix table that the column vendor is being pulled from a helper table called Vendor_template which has specific vendors as rows along ...
  • danextian's avatar
    1 year ago

    It would have been easier for us to provide a solution had you provided a sample pbix (confidential data removed). But just given what's available, here's what I would try: Keep a separate measure for vendor level only. Create another measure to return the total

    TotalSellPrice_BillsReceived - Vendor and Total =
    IF (
        SELECTEDVALUE ( Vendor_Template[Vendor Reference] ) = "Total",
        SUMX (
            VALUES ( VendorProjectType[Manufacturer] ),
            [TotalSellPrice_BillsReceived - vendor]
        ),
        [TotalSellPrice_BillsReceived]
    )