Serial number on grouped data for based on one column itself which are text columns

Hi Jessica_17 

If you want to get the max value of the measure, you can refer to the following measure

Max_measure_no =
CALCULATE (
    MAXX ( 'public bi_job_hist cntr_attr', [Measure] ),
    ALLSELECTED ( 'public bi_job_hist cntr_attr' ),
    'public bi_job_hist cntr_attr'[Hour_step]
        IN VALUES ( 'public bi_job_hist cntr_attr'[Hour_step] )
)

if you want to get the max value of the eq_no,  you can refer to the following measure

Measure_eq_no =
MAXX (
    FILTER (
        ALLSELECTED ( 'public bi_job_hist cntr_attr' ),
        [Hour_step] IN VALUES ( 'public bi_job_hist cntr_attr'[Hour_step] )
    ),
    [bi_jh_eq_no]
)

Output

Best Regards!

Yolo Zhu

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