Forum Discussion
Count First Value in Column - for a day
I need to count the Values "Estado" (Bold & Blue) in the Column for each day, not Repeating the same ESTADO, reaching a final result of 10, over the 13 rows.
Example:
1Feb = 1
2Feb = 1
26Feb = 1
| ID | Fecha | Estado | |
| 1 | 01-Feb | Order Entry | email1 |
| 2 | 01-Feb | Order Entry | email2 |
| 3 | 02-Feb | Order Entry | email3 |
| 4 | 20-Feb | Pendiente de Codigo | email4 |
| 5 | 26-Feb | Pendiente de Codigo | email5 |
| 6 | 26-Feb | Pendiente de Codigo | email6 |
| 7 | 03-Mar | Pendiente de Codigo | email7 |
| 8 | 03-Mar | Order Entry | email8 |
| 9 | 03-Mar | Pendiente de Revision | email9 |
| 10 | 03-Mar | Aprobado | email10 |
| 11 | 03-Mar | Aprobado | email11 |
| 12 | 11-Mar | Pendiente de Revision | email12 |
| 13 | 11-Mar | Aprobado | email13 |
Hi emf_efab
You can do this with this measure
Count Estado = COUNTROWS(DISTINCT(SELECTCOLUMNS('Control Emails', "NewCol", 'Control Emails'[Fecha]&'Control Emails'[Estado])))Regards
Phil
Thank you very much Phil, regards Steve
8 Replies
Hi emf_efab
You can do this with this measure
Count Estado = COUNTROWS(DISTINCT(SELECTCOLUMNS('Control Emails', "NewCol", 'Control Emails'[Fecha]&'Control Emails'[Estado])))Regards
Phil
Thank you very much Phil, regards Steve
HI emf_efab
Not following the logic for what to count.
You've highlighted the first Estado for 1-Feb, 2-Feb, 20-Feb and 26-Feb but then you've highlighted multiple things for 3-Mar and 11-Mar.
Regards
Phil
Phil,
Thanks for helping...I need to count the "Estado" no matter what the estado is for a day, but NOT REPEATING the same "estado" for a same day.
I need to keep control of all the single ESTADOS in the complete rows.
So in the example you have 13 rows but the ocurrences are 10 without repeating the ESTADO.
Whope you understand me this time.
Hi emf_efab
Right, I understand now.
How do you want this count presented? As a single number as the result of a measure?
Regards
Phil