Count First Value in Column - for a day

[emf_efab]

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	Email
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

[PhilipTreacy · Accepted solution]

Hi @emf_efab 

Download PBIX

You can do this with this measure

Count Estado = COUNTROWS(DISTINCT(SELECTCOLUMNS('Control Emails', "NewCol", 'Control Emails'[Fecha]&'Control Emails'[Estado])))

Regards

Phil

[PhilipTreacy · Accepted solution]

Hi @emf_efab 

Download PBIX

You can do this with this measure

Count Estado = COUNTROWS(DISTINCT(SELECTCOLUMNS('Control Emails', "NewCol", 'Control Emails'[Fecha]&'Control Emails'[Estado])))

Regards

Phil

[emf_efab · Accepted solution]

Thank you very much Phil, regards Steve

[PhilipTreacy]

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

[emf_efab]

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.

[PhilipTreacy]

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

[emf_efab]

As a "number", in the example I should arrive to 10. It should be a Measure, that shows me the total "Ocurrences" for an Order for example. Do you need the Excel file, and the PBIX ??, not to lose time creating it.

[PhilipTreacy]

Hi @emf_efab 

Yes the file/PBIX would help.

Thanks

Phil

[emf_efab]

How do I send it to you, or where do I attach it. Sorry it's my first time here, in 5 years. Never used this space.

This is a Shared Drive:

https://drive.google.com/drive/folders/12VY2dKytqM92pVemdY_Bpk00ph_jI1um?usp=sharing