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.

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

Hello Anonymous 

Thanks for the solution it worked,
one more doubt, how can I get the max value for each hour_step in another measure?

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