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 

You can create a measure

Measure =
RANKX (
    FILTER (
        ALLSELECTED ( 'public bi_job_hist cntr_attr' ),
        [Hour_step] IN VALUES ( 'public bi_job_hist cntr_attr'[Hour_step] )
    ),
    CALCULATE ( MAX ( 'public bi_job_hist cntr_attr'[bi_jh_eq_no] ) ),
    ,
    ASC,
    DENSE
)

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