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.

AntonioM's avatar
AntonioM
Solution Sage
4 years ago

An additional table would work and you'd only need to keep the code and id columns. 

 

Then you'd link that to your original table on id, change the filter direction to be New table -> Original table and then use the 'New table'[code] in your slicer.

 

Now when you choose a code in the slicer, it filters your original table by that code's id

 

How big is your data model? Do you think that would that be too much to add in?

unkCandy's avatar
unkCandy
Helper I
4 years ago

yes, I tried adding new table but it will make the data model more complicated.