Forum Discussion
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...
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.
Hi unkCandy ,
Please can you check the below screenshot, if this is the solution that you are looking for.
Thank you,
Vishesh Jain
no it is not, I want to get all IDS if the code selected is between the ID's code.