Forum Discussion
Help with slicer/table visual and contexts
Thanks all for the help. I was able to resolve this. I needed create another relationship between Table3 and Table1 (based on the name many-to-many). I was then able to use that relationship, the name of the person from Table3, the name of the company from Table2, ignore all the rest of the filters (ALL(Table1)) and add a set of filters which match the name and the company from above. This resulted in empty data for all names and the correct data for those who matched. I was able to filter the empty's in the visual and that did the trick.
Thanks again for all your help.
+Ram
Hi RamEHG ,
I reviewed the post and I have a question for you.
I saw the relationship is 1:*, but in Table 2, there're 2 Comp1 and 2 Comp2 in it, therefore they can't be set up as one to manay.
If you want the expected result you mentioned, you could change your relationships as below.
Here's the result:
The slicer is created from Table 3. In the table visual, Company field, Name field and the countings are from Table 1.
You can check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks again for the response. I made a mistake in the relationships - it should be Table2 -> Table1 (1:*) (Name -> Name). Essentially I have an person table (Table2) and an meetings table (Table1). Each of these have varying attributes. I'm trying to have a slicer with a person name. Selection of a particular person should then show me all other people in the same company alongside the count of meetings each of those people have had. Hence the creation of Table3 so that I can discern "other people who worked with the selected person". And then I'm trying to get the count of meetings for each of them. It seems that I'm not able to get the row context shown from Table3 to apply to Table1 in this process.
Thanks
Thanks again
Ram