Count for multiple filters and criterias

[Anonymous]

Hi. I need some help trying to count how many values are in the table filtering with multiple criterias. Here as short view of the table that I got. 

Basically i need to get the numbers in the column "Products per shift" in red. So I need to count how many Products where in one day and in exact shift. Maybe some advice from You guys? 

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

Try following

=
CALCULATE (
    DISTINCTCOUNT ( TableName[Products] ),
    ALLEXCEPT ( TableName, TableName[Date], TableName[Shift] )
)