COUNTIFS with Multiple Statements referring to Current Row value

[SteveMBSDO]

For each row, I want to get a unique following number per Focus Tank. In Excel I accomplisted this by a COUNTIFS statement:

COUNTIFS if:

Column [Focus Tank] matches the [Focus Tank] value of the current row.

Column [NewStart] is less than or equal to the [NewStart] value of the current row.

Works a charm.

In PowerBI I came up with this, but it is not functioning because I don't know how to make code "VALUE(45907.74585)" dynamic. Meaning, this value should get the value from it's current ROW, and not be hardcoded. Anyone know what I'm missing here?

Thanks!

[Dangar332]

HI, @SteveMBSDO 

if it is measure then try below
measure =
var a = max(tablename[column name from value coming])

and compare it like (<a instead of  values(...))

code like
measure =
var a = max(tablename[column name from value coming])

return

countx(

..........,

.....[datetime chrono]<a

)

if its column then 
var a = tablename[column name from value coming]

[SteveMBSDO]

Hi @Dangar332 , sorry I forgot to mention it's a table.

[Dangar332 · Accepted solution]

Hi, @SteveMBSDO 

transaction =
var a = 'transaction database'[datetime chrono]
return
countx( 
filter('transaction database',
'transaction database'[focus tank]=30 &&
'transaction database'[datetime chrono]< a
),
'transaction database'[datetime chrono]
)

[SteveMBSDO]

Hi, @Dangar332  Awesome! Thank you. I've also added the dynamic focus tank to the list of variables: