Forum Discussion
sajohnson05
1 year agoFrequent Visitor
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 ...
- 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] )
Ashish_Mathur
Super User
1 year agoHi,
Share the download link of the PBI file. Show the problem and expected result there.