Forum Discussion
Count blanks in matrix
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:
2 Replies
Anonymous , Try a new measure like
Sumx(summarize(table, Table[Department], Table[Day]), calculate(if(isblank(coutrows(Table)), 1,0 )))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".
