Slicer to show and not show information

[ipon70]

I need to be able to pick a Person, then have the slicer change one table to show of the 100 days available what they have used, and what is left. So if I picked Joe he would show lets say 5 days used and 95 days left.

There is a list that is updated randomly  with new days that people can take.

This list is just a name with hours so it could be listed as "Veterans Day" and 8 hours, then it could be "Labor Day" and 8 hours, and then it could be "Christmas 2024" and 8 hours.

Obviously this list will have tons of days that will show available.

I need to be able to pick Joe and show Joe used "Veterans Day" but still has "Labor Day", and "Christmas 2024" available.

So like a forward normal list with a slicer and a reverse one that shows the opposite of what is selected.

Hopefully that makes sense. 

[Greg_Deckler · Accepted solution]

@ipon70 If this doesn't do it for you please post sample data: (3) Inverse Aggregator - Microsoft Fabric Community

[ipon70]

Trying it now and will report back.