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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,216,025
Messages
6,128,356
Members
449,444
Latest member
abitrandom82

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