DAX SUMIFS equivalent **without** hardcoding criteria or slicer selection

[kahnailee]

I've tried searching forums on this and found FILTER, CALCULATE, RELATED, combo of everything and nothing appears to be working for what I'm trying to accomplish.

Goal: Determine total rebate dollars based on a supplier and brand, but NOT based on a hard-coded supplier or brand, nor based on a slicer selection. Well, not exclusively at least.

See my screenshot of example data, along with the desired output(s).

[TeigeGao · Accepted solution]

Hi @kahnailee ,

Please create a measure using the following query:

Rebate Dollars =
CALCULATE (
    MIN ( Table1[ExtendedPOCost] ),
    FILTER (
        ALL ( Table1 ),
        Table1[Date] = DATE ( 2019, 1, 1 )
            && Table1[Supplier] = MIN ( Table2[Supplier] )
            && Table1[Brand] = MIN ( Table2[Brand] )
    )
)
    * MIN ( Table2[Rebate] )

The result will like below:

Best Regards,

Teige