Count of rows with two conditions -different tables

[jbmmobile]

Hello,

Need help with counting. I would like to have a calculated column table1[column2] with the total qty for value "000001_UPS_P_RES" in table2[ship method code] counted by table[invoice date] using table1[date] as the reference to match the dates

So for ship method code 000001_UPS_P_RES I would like to count how many time it appears for Invoice Date in table 2 using the date column in table 1  and displayed in table1[column2] 

I hope this makes sense. Thanks in advance for the help

[Greg_Deckler · Accepted solution]

Probably multiple ways of doing this, here is one.

In ShipCode table (table 2), create a measure like:

mCountShipCodes = COUNTROWS(ShipCodes) 

Make sure your tables are related on date.

Create table visualization that has [Date] (from table 1), ShipCode from table 2, and your measure.

[Eric_Zhang · Accepted solution]

@jbmmobile

If no relationship between two tables, you can also try

Column2 = COUNTROWS(FILTER(Table2,Table2[ship method code]="000001_UPS_P_RES"&&Table2[invoice date]=Table1[Date]))

[Greg_Deckler · Accepted solution]

Probably multiple ways of doing this, here is one.

In ShipCode table (table 2), create a measure like:

mCountShipCodes = COUNTROWS(ShipCodes) 

Make sure your tables are related on date.

Create table visualization that has [Date] (from table 1), ShipCode from table 2, and your measure.