Forum Discussion

jkesavan's avatar
jkesavan
Frequent Visitor
5 years ago

Grouping same numbers together

Hi all, i am trying to create a new colum i guess, that might give a total count of how many of the exact same Job ID's are there. But the same job ID's must be grouped together. 

 

For example job 165245 should only return 1 count instead of 14 although its entered 14 times. It still has the same JOb ID value.  

but job. Could someone please walk me through this process. 

 

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    jkesavan , Not Very Clear

    Try like

    distinctcount(Table[Job ID])

     

    or

     

    sumx(values(Table[Job ID]), distinctcount(Table[Job ID]))

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi jkesavan ,

    I cannot understand what your expected result will be. Do you want the distinct values of Job ID like this:

     

    Or something like this:

     

    Or this?

     

    Below is the sample data (‘Table’) I used:

    Best Regards,

    Community Support Team _ Jing Zhang

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