Forum Discussion
Solved
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...
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
Right, I understand now.
How do you want this count presented? As a single number as the result of a measure?
Regards
Phil
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.
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