Hello all,
I have tried, repeatedly, to put in place a multiple condition based on a filter table. I got it to work for like an hour or two, then all of a sudden it didn't work any more. I have reviewed and tried all of the examples I can find in this community, but none of them seem to work for me.
I have a junction table from which I am attempting to pull rows to match the filter. Not all of the desired columns are in the junction table; I am attempting to use dereferences to link down to the values in the referenced tables.
I constructed a filter table and a filter editing view. It works perfectly. However, when the slice filter runs against that filter table, it returns no data. I am sure the issue has to do with something small, but I simply cannot find it.
The expression below (Row Filter for Slice) is the only one that ever worked to pull the correct data...but then a few hours later it wouldn't pull the data any more. I don't think I changed anything in the table that would affect this and I KNOW for certain I didn't change anything in the slice or the view that displays the slice. I am at a complete loss.
ISNOTBLANK(
FILTER("tbl_filter",
AND(IN([_THISROW].[Role].[Role],Split(tbl_filter[Role],",")),
IN([_THISROW].[Item].[Assigned].[Assigned],Split(tbl_filter[Assigned],",")),
IN([_THISROW].[Item].[Type].[Type],Split(tbl_filter[Type],",")))))
Any help would be greatly appreciated.
LinkedIn
Twitter
