Filtering main table through a calculated table with slicer

[Applicable88]

Hello,

im having a factable like this with all occurences:

Failurenumber	Failurecode	Date
(8888)1234	L8888	21.06.2021
(8888)1235	L8888	22.06.2021
(8888)1236	L8888	23.06.2021
(8888)1237	L8888	24.06.2021
Other Issues	L1000	25.06.2021
Other Issues	L1100	26.06.2021
Machine Failure	L5555	27.06.2021

For switching the two modes where I either want to see all Failurecodes or just the filtered ones with the code called "L8888" I'm using a calculated table with following formular:

Filtered Table= SUMMARIZE(FILTER('Errortable', 'Errortable'[FailureCode] in {"L8888"}),'Errortable'[Failurenumber]

, "Filtered" , "Filtered")

The outcome is following table which is totally correct:

Filtered	Failurecode
(8888)1234	L8888
(8888)1235	L8888
(8888)1236	L8888
(8888)1237	L8888

I'm now connecting the Filtered column with Failurenumber of my maintable in a bidirectional relationship. I also get 1:N cardinality. But when I now create a slicer "Filtered" for on and off, I'm using the same above mentioned formula to activated the filtered table, somehow in the maintable nothing changes. Since all "filtered" are activated now, shouldn't the factable also react accordingly?

I hope someone has an idea has an idea here.

Thank you in advance.

Best. 

[amitchandak · Accepted solution]

@Applicable88 , a Calculated table will not respond to the slicer values. 

You need to create a measure and use that in visual table 

[amitchandak · Accepted solution]

@Applicable88 , a Calculated table will not respond to the slicer values. 

You need to create a measure and use that in visual table 

[Applicable88 · Accepted solution]

I found another way, to just use the formula and put it right into the original table as a calculated column.  This way it had no problem filtering the data according to "filtered". 

Thanks

[Applicable88]

Hello @amitchandak thanks of the quick reply, but in case I want to switch between "all" and "filtered" how to to that? When the measure is in the table it returns scalar value. A measure cannot be put into the slicer only a dimension can be put in there.