DAX SUMIFS Equivalent?

DAMCars

New Member
Joined
Jul 29, 2016
Messages
2
Hello. I'm trying to write a DAX formula that works like SUMIFS for 2 unrelated tables. I know there are work arounds and that I can modify the table content itself but I don't want to do that. Lets just assume that the data in the below example has to remain as is.

In the CurrentTable, I am trying to calculate the clicks that I show under the Clicks "Correct" column but i'm getting the clicks that I show under the Clicks "Wrong" column.

I am using the following DAX formula:

=SUMX(FILTER('VendorTable','VendorTable'[Model]=[Model] && 'VendorTable'[Date]=[Date]),'VendorTable'[Clicks])

This is super easy to achieve in Excel via Sumifs but i can't make it work in DAX.


CurrentTableWrongCorrect
ModelDateClicks Clicks
Mercedes E Class7/27/2016370300
Mercedes E Class7/27/2016370300
Audi A67/27/201637070
Mercedes E Class7/27/2016370300
Audi A67/27/201637070

<tbody>
</tbody>

VendorTable
ModelDateClicks
Mercedes E Class7/26/201680
Mercedes E Class7/27/2016100
Mercedes E Class7/27/2016200
Audi A67/26/201650
Audi A67/27/201670

<tbody>
</tbody>
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,216,001
Messages
6,128,211
Members
449,435
Latest member
Jahmia0616

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top