Forum Discussion

emf_efab's avatar
emf_efab
Frequent Visitor
5 years ago
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...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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's avatar
    emf_efab
    5 years ago

    Thank you very much Phil, regards Steve

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

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's avatar
emf_efab
Frequent Visitor
5 years ago

Thank you very much Phil, regards Steve