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

emf_efab's avatar
emf_efab
Frequent Visitor
5 years ago

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's avatar
PhilipTreacy
Super User
5 years ago

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

    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.