Row belongs to several slices

Hello everyone! I faced a problem, trying to make a database for a lab.

The situation is following: We have patients, who are prescribed for different tests: test_1 , test_2 and  vip_test_3. Test_1 and test_2 had been grouped to one slice, vip_test_3 patients are shown in another slice. But, if patient is prescribed for test_2 and vip_test_3  - his row is not shown in any of described slices (but should be in both). How can I solve this? Thanks in advance

The column [Prescribed tests] has a Enumlist format

0 2 54
2 REPLIES 2

Steve
Platinum 4
Platinum 4

The Prescribed tests column should be of type EnumList, and your slice row filter expressions should be using the IN() function to examine that column.

Welcome to the community! 

Row filter condition in one slice should not be affected by whatever there is in another slice. I believe there should be a problem with your expression or how it relates to your data. Can you please show us the expressions you are using for the slices and the columns of your table? Thank you.

Top Labels in this Space