Column: Count of Previous Column

[HenryJS]

Hi all,

How can I add a column which has a count of the 'Candidate + Date' column?

So for the bottom highlighted rows it would be 5 as they appear 5 times.

[FrankAT]

Hi @HenryJS 

you can do it like this:

Count of Candidate + Date = 
CALCULATE(
    COUNT('Table'[Candidate + Date]),
    ALLEXCEPT('Table','Table'[Candidate + Date])
)

Regards FrankAT

[AllisonKennedy]

Sorry, I don't understand what you're asking. A couple of questions:
1) Why does this need to be a column? What is the end goal and can it be done as measure?
2) Why is the answer 5? Do you want to count the total rows with the same value in the Candidate-Date column?

Try new column:
Rows = COUNTROWS(FILTER(ALL(table), table[Candidate-Date] = EARLIER(table[Candidate-Date]))

[amitchandak · Accepted solution]

@HenryJS , a new column like

countx(filter(table, [candidate+date] =earlier([candidate+date])),[candidate+date])