DAX summarize count of values filtering on a different column

[andre_kauber]

I'm stuck on a simple one, also looked in the dax manual but I'm not able to find the solution. 

I want to obtain a count of, say, transactions by date, filtering on a different column. So, let's say I have the table 'cool', the columns [Date], [Transactions], and a third column with object sold [Object]. I want to create a new table, containing the dates and the count of transactions.

Table = SUMMARIZE('Cool','Cool'[Date],"Sales",COUNT('Cool'[Transactions]))

Now, how can I obtain the count of transactions per date for 'Cool'[Object]="Toy"?

Thanks

[v-yulgu-msft · Accepted solution]

Hi @andre_kauber,

You could modify your formula as below:

Table =
SUMMARIZE (
    FILTER ( Cool, Cool[Object] = "Toy" ),
    Cool[Date],
    "Sales", COUNT ( Cool[Transactions] )
)

Regards,
Yuliana Gu

[Feliciano]

Hello! What I have to do if I need filter by two or more criterias?

[andre_kauber]

Thank you!