Forum Discussion

unkCandy's avatar
unkCandy
Helper I
4 years ago
Solved

Group by and get all IDS while Filtering a table

Hello Community,    I would like to get all IDS while filtering by code.  I have a dataset that has: Code, ID, Number, key there is a different Code for the same ID the same ID has the sa...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, unkCandy 

     

    You can try the following methods.

    Table:

     

    Table = VALUES(data[code])

     

    Measure:

     

    Measure = IF(SELECTEDVALUE(data[code]) in VALUES('Table'[code]),1,0)

     

    Place the measure in the view with ID and set it equal to 1.

    Is this similar to the result you expect?

     

     

    Best Regards,

    Community Support Team _Charlotte

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

visheshjain's avatar
visheshjain
Impactful Individual
4 years ago

Hi unkCandy ,

Not sure if I am missing anything but in the filter pane of the visual, you have the ID selected as 762.

If you remove that your report should work alright.

 

Please let me know if this helps and mark is as the solution so that others can reach the solution faster.

 

Thank you,

Vishesh Jain

  • unkCandy's avatar
    unkCandy
    Helper I
    4 years ago

    Thank for your reply, for the filter, I just want to show what it is the outcome will be, when I selected a code I can get all IDS that has the selected code in their code. 

    • visheshjain's avatar
      visheshjain
      Impactful Individual
      4 years ago

      Hi unkCandy ,

       

      Please can you check the below screenshot, if this is the solution that you are looking for.

      Thank you,

      Vishesh Jain

      • unkCandy's avatar
        unkCandy
        Helper I
        4 years ago

        no it is not, I want to get all IDS if the code selected  is between the ID's code.