Slicer doesn't work because of other measure

[L_K_]

Hello!

I've been having a problem with a specific visualization that I would need some help with. 

I also have to have a lot of filters within the measures to get the exact data I need.

I have a Table1 that looks kind of like this:

ID_EMP	ID_NUM1	ID_NUM2	VALUE	SLICER
1	101	20	123,40
1	102	20	23,40
1	103	20	2,30
1	104	20	2,10	2,10
1	106	21	12,30
1	107	21	123,30
1	108	21	122,40
1	109	21	200,00
1	110	22	211,00
1	111	22	12,40
1	112	22	123,10
1	113	22	11,20
2	101	20	133,20
2	102	20	32,40
2	103	20	1,20
2	105	21	3,10	3,10
2	106	21	22,10
2	107	21	134,20
3	101	20	122,10
3	102	20	11,30
3	103	20	2,10
3	104	20	2,40	2,40
3	106	21	11,40
4	103	20	2,10
4	104	20	3,20	3,20
4	106	21	13,10

The slicer column is a measure.

SLICER = IF(CALCULATE([VALUE],(Table1[ID_NUM1]=105 && Table1[ID_NUM2]=21) || (Table1[ID_NUM1]=104 && Table1[ID_NUM2]=21))>0,[VALUE],BLANK())

In my visualization I have a table like this:

ID_EMP	NAME	VALUE_1	VALUE_2
1	John	123,40	2,10
2	Emma	133,20	3,10
3	Tom	122,10	2,40
4	Bob		3,20

VALUE_1 = calculate([value],Table1,Table1[ID_NUM1]=101,Table1[ID_NUM2]=20)
VALUE_2 = calculate([value],Table1,(Table1[ID_NUM1]=105 && Table1[ID_NUM2]=21) || (Table1[ID_NUM1]=104 && Table1[ID_NUM2]=21))

I don't want to show rows with missing VALUE_1 data. So I filtered the table that VALUE_1 is not blank.

ID_EMP	NAME	VALUE_1	VALUE_2
1	John	123,40	2,10
2	Emma	133,20	3,10
3	Tom	122,10	2,40

Now I need to add a Slicer for the VALUE_2 measure. So I created the slicer measure/column, but when I want to filter my table by the slicer values it shows an empty table, because of the table filter VALUE_1 is not blank. If I disable the filter the slicer kind of works, but it doesn't show the VALUE_1 data, it only shows VALUE_2 data and it shows the employees I don't want included.

I know what the problem is but I don't know how to solve it.

What I want to achieve is, that I can display four measured values for each employee in a table, one measure can’t be blank, and I want to have a slicer for the second measure, but all values have to be shown in the rows. If it makes sense?

Can this be done?

Kind regards,

L