Forum Discussion
show difference between tables
It looks like you have used Edit Interations to setup your slicers so that they only affect each individual visual. The problem is that this works visually but if you create a measure for conditional formatting, it will have a devil of a time figuring out what is going on. I would recommend four date tables, Table 1: Created Date, Table 2: Updated Date, Table 3: Created Date, Table 4: Updated Date. You could link them to your table date table -> fact table.
Then, you can use SELECTEDVALUE to grab the selected value from each of these tables (the value in your slicer). Now you should be able to use ALL to break out of filter context and see if a File that appears with the created date and updated date from tables 1 and 2 also appears when filtering by 3 and 4.
If you post sample data as text, I can be more specific.