Reverse slicer with calculation and interaction with other slicer

[IWallis]

Hi,

I have a dataset that contains a list of articles that have been read by customers, and I am hoping that when I use a slicer to select a customer, I can have a list of articles that have not been read by that customer. I was able to do so using the measure below:

Inverse Selector =

var _Category = MAX('ReportSuggestRead'[ReportFileID])

var _Categories = VALUES('ReportID'[ReportFileID])

var _table = SELECTCOLUMNS(FILTER(ALL('ReportSuggestRead'), 'ReportSuggestRead'[ReportFileID] in _Categories), "_Category",'ReportSuggestRead'[ReportFileID])

var _filter = FILTER(ReportSuggestRead, _Category in _table)

Return if(_Category in _table, BLANK(),1)

and get a result like this below: (left table is the one been read by the customer, right table is the one that not read)

However, I am hoping I can only show the top reports (read by other customers but not this one by counting the viewdate) and also hope I can use a slicer to select a report topic (using report tag) and only show that topic with the top 10 articles. But I couldnt figure out how to do it....does anyone have any idea that would work? My data structure is below:

Thank you so much!

[DataVitalizer]

Hi @IWallis 
Take a look at this post it looks similar to what you are trying to achieve

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Display-Not-selected-values-from-Slicer-Consi...

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[IWallis]

Hi @DataVitalizer , thank you for providing the reference. However, that code doesnt work for me.....