Count blanks in matrix

[Anonymous]

Hi can you please help me solve my problem, 

I have a matrix showing the amount of times a transaction has been executed. I want to show the combination of department and days that are blank. For this store the count would be 6.

To help a simplified table in English.

I want to count the Departments for eacht branche, with zero transactions (marked red). 

Branche (table_location)	Article (table_article)	Department (table_article)	Transactions (table_transactions)
1	101	1	34
1	102	1	5
1	103	1	0
1	104	2	0
2	101	1	12
2	102	1	33
2	103	1	3
2	104	2	3
3	101	1	0
3	102	1	0
3	103	1	0
3	104	2	0

So the result would be:

Branche	Department	Countblank
1	1	0
1	2	1
2	1	0
2	2	0
3	1	1
3	2	1

The formula I use is the following:

Countblanks = calculate (

    COUNTROWS(table_article),

    Filter (table_transactions, Isblank ([Transactions])))

The problem is that I am filtering on the whole table_article, leading to a count on article level. So i do not see the count of 3, but 5. What I need is a count on Department level. It is probaby easy to fix, but it is already taking me hours. Please help:)

[amitchandak]

@Anonymous , Try a new measure like
Sumx(summarize(table, Table[Department], Table[Day]), calculate(if(isblank(coutrows(Table)), 1,0 )))

[Anonymous]

@amitchandak thanks for the suggestion, maybe I did not represent the table structure in the correct way, but I cannot make the measure as you suggest. I want to count the amount in table "voorraadmutaties".