Forum Discussion
Get rows from selection to use as filter
Hello
I have product reviews and there is a need to see how the users who have given bad or good reviews have answered other questions.
The sample datamodel is as follows:
| Product | CustomerId | Parameter | Review 1(bad) - 5(good) |
| A | 1 | Param1 | 1 |
| A | 1 | Param2 | 1 |
| A | 1 | Param3 | 4 |
| A | 2 | Param1 | 4 |
| A | 2 | Param2 | 3 |
| A | 3 | Param1 | 4 |
| A | 3 | Param1 | 5 |
| A | 4 | Param1 | 5 |
| A | 5 | Param1 | 1 |
| A | 6 | Param1 | 4 |
| B | 1 | Param1 | 3 |
| B | 4 | Param1 | 4 |
| B | 5 | Param1 | 4 |
I wanna for instance see all customers who have given the rating 1 for product A - as shown below.
I can see that it is CustomerId 1 and 5 who has given review=1.
And then I want to see all the answers they have given.
If I click on the CustomerId-table and click on CustomerId 1- I can see all the reviews he/she have given.
But I wanna see the answers for all the Customers who has given the rating 1.
And lets say I had 200 CustomerId's that had given a bad review - and I wanted to see all the answers given by these. Then I would have to memmorize all 200 customerIds and hold down CTRL and click on all the CustomerId's in this table. Is there an easier way to filter out these CustomerIds and show the answers they have given?
Note: the review is not always 1-5 for all product reviews - sometimes it is 1 - 10 or A - E or something else - so I need to find a generic solution.
Thanks!
Best regards
Hi comm_line ,
see my pbi file. Let me know if the link does not work
https://1drv.ms/u/s!Aj45jbu0mDVJiynU256pPyq6qOLp?e=pEFGfr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- mangaus1111
Solution Sage
Hi comm_line ,
see my pbi file. Let me know if the link does not work
https://1drv.ms/u/s!Aj45jbu0mDVJiynU256pPyq6qOLp?e=pEFGfr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.