Count distinct rows with multiple criteria

[joslaz]

Hello everyone!

I am struggling with a pretty simple problem at the moment.
I have the following two tables in the data model (power pivot)


tblGeneral
ID - Date - Value - Typ:


tblWO
ID - Date Start - Date Finished - Value - State - Typ

ID: ABC
Date: DD.MM.YYYY HH:MM:SS
Value: 250
Type: X or E
State: 00-99

Now I want to create a column in tblGeneral with the following criteria
Where
tblGeneral.Date = tblWO.Date Start
tblGeneral.Type = X
tblWO.State =>21


How can I manage that?
How would be the formular? I already started with COUNTX or COUNTAX... but it doesnt't work


Best Regards
Joshua