how to filter by total sum and not row sum

[mroi]

hello,

I would like to display a table filtered by the total amount of purchases by supplier (purchases per supplier > 140 thousand)

The columns indicate different offices so that you can see the amount of purchases in each office with a summary column.

When I add the invoice number to the rows of the table (below the vendor number +), the filter refers to the invoice amount and not the total amount by vendor.

How can I create a measure that shows the total amount by supplier regardless of the invoice detail, and perform the filtering according to that measure?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your data model looks like, but please try something like below and check whether it suits your requirement.

expected result measure: =
CALCULATE (
    SUM ( 'TableName'[InvoiceAmount] ),
    ALL ( 'TableName'[InvoiceDetail] )
)

Or,

expected result measure: =
CALCULATE (
    SUM ( 'TableName'[InvoiceAmount] ),
    ALLEXCEPT ( 'TableName', 'TableName'[VendorNumber] )
)

[mroi]

Thank you for the quick response and for the simple and elegant solution.