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.
<tbody>
</tbody>
<tbody>
</tbody>
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.
CurrentTable | Wrong | Correct | |
Model | Date | Clicks | Clicks |
Mercedes E Class | 7/27/2016 | 370 | 300 |
Mercedes E Class | 7/27/2016 | 370 | 300 |
Audi A6 | 7/27/2016 | 370 | 70 |
Mercedes E Class | 7/27/2016 | 370 | 300 |
Audi A6 | 7/27/2016 | 370 | 70 |
<tbody>
</tbody>
VendorTable | ||
Model | Date | Clicks |
Mercedes E Class | 7/26/2016 | 80 |
Mercedes E Class | 7/27/2016 | 100 |
Mercedes E Class | 7/27/2016 | 200 |
Audi A6 | 7/26/2016 | 50 |
Audi A6 | 7/27/2016 | 70 |
<tbody>
</tbody>