(Calculated column) Count any row if column value = row value

[sfooshee]

So I've got a COUNTIFS excel formula (calculated) that counts any row that meets multiple criteria, including matching a value on the current row. But it is a calculated column so I can't just use " " to find a value, it needs to match whatever is on the row.

My excel formula looks like this:

COUNTIFS(AM:AM,"Completed",D:D,[@[Visit Date]],N:N,[@First Name],AO:AO)>0

So I need a DAX formula that does that. It can search a column for a value that matches the current row. Any thoughts?

[v-deddai1-msft]

Hi @sfooshee ,

Have you sovled your issue? If not, would you please show us some sample data and your expected result. Then we can help you more accurately.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Vera_33 · Accepted solution]

Hi @sfooshee 

It's better to provide some sample data (in a format people can copy) with expected result. I don't understand your COUNTIFS without enough context, but basically you can do DAX calculated column like below, if you have multiple conditions, use &&

Column = COUNTROWS(FILTER('Table','Table'[yourColumn]=EARLIER('Table'[yourColumn])))

OR

Column = 
VAR CurValue = 'Table'[yourColumn]
RETURN
COUNTROWS(FILTER('Table','Table'[yourColumn]= CurValue))