Forum Discussion

Jessica_17's avatar
Jessica_17
Icon for Helper V rankHelper V
2 years ago
Solved

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

Hello All, Can anyone please help me, I have a table which has datetimestamp, each datetimestamp has name which can be integer or text value, I want to create a serial number in table visualization ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

Jessica_17's avatar
Jessica_17
Icon for Helper V rankHelper V
2 years ago

Hello Anonymous 

I want rank value , but it is not working for me it is showing 1 as value, whereas I want 19 as max value, and hour_step and eq_no columns are text in my case

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jessica_17 

    The measure can work in my data, can you provide the code you have input?and the requirement is a new requirement, you can create a new post and if my solution above help to solve the original question, please consider to mark it as a solution.

     

    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.

     

    Best Regards!

    Yolo Zhu