Dax Count concurrent identical values

Hi , Fisask 

According to your description, you want to group by [ALL.project] and show the maximum number of consecutive occurrences of the same [ALL.overall_health]. Right?

Here are the steps you can follow:

(1) This is my test data :

(2) You can click "New column" to create two calculated columns:

flag = 
var _current_pro='Test'[ALL.project]
var _pro_max_date= MAXX( FILTER('Test', 'Test'[ALL.project]=_current_pro ) , [ALL.as_on])
var _pro_color=MAXX( FILTER('Test','Test'[ALL.project]=_current_pro && 'Test'[ALL.as_on] = _pro_max_date),[ALL.overall_health] )

return 
IF('Test'[ALL.overall_health]=_pro_color ,1,-1)

Count = 
var _current_pro='Test'[ALL.project]
var _pro_m1=MAXX( FILTER( 'Test' , 'Test'[ALL.project]=_current_pro && 'Test'[flag]= -1 ),[ALL.as_on])
return
SUMX( FILTER( 'Test','Test'[ALL.project]=_current_pro && 'Test'[ALL.as_on] >_pro_m1 ),[flag])

(3)Then we can put the [Count] and the [ALL.project] field in the table visual.The result is as follows:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

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