Slicing a visual while excluding the selected value from the visual

[PBI_AMS]

I am analyzing subscriber data.  I have 100k plus subscribers who have opted into up to 10 topics. What I want to be able to see is: If you are a subscriber to topic C, what OTHER topics are you also subscribed to?  To do this, I have created a contact filter table and contact output table with many-to-many connection on contact GUID.  If I select topic C in a slicer from the filter table, I can see a bar chart of topics A-J using data from the output table.  This visual shows topic C as the highest number of subscribers but also shows what other topics those subscribers are interested in.  This provides some insights from multi-select as well. X # of subscribers to C AND/OR F will also be interested in J.  However, the behavior I want is to EXCLUDE any items I've selected in my Slicer from the output visual. My searches have yielded several (nifty!) tutorials for how to create a slicer to exclude selected items from a visual but not while simultaneously slicing that visual by those selections.  Any help?  

[PBI_AMS]

Okay, maybe I just had to type that out to get to my answer.  I created thie following measure to use in the visuals, and it works like a charm! 

ExcludedTopics = CALCULATE( COUNTROWS(ContactOutputTable), FILTER( ContactOutputTable, NOT(ContactOutputTable[Topic] IN VALUES(ContactFilterTable[SelectedTopic])) ) )

[v-sshirivolu]

Hi @PBI_AMS ,

Thanks for reaching out to the Microsoft fabric community forum.

Try this DAX measure :

ExcludedTopics =
CALCULATE(
COUNTROWS(ContactOutputTable),
FILTER(
ContactOutputTable,
NOT(ContactOutputTable[Topic] IN VALUES(ContactFilterTable[SelectedTopic]))
)
)

Given DAX Satifies these requirements :

VALUES(ContactFilterTable[SelectedTopic]) -Captures the topic(s) selected in the slicer.

NOT(...) - Ensures selected topics are excluded from the visual.

CALCULATE + FILTER -  Contextually filters ContactOutputTable to show only relevant rows (i.e., other topics for those same contacts).

Then place this measure in a bar chart where Topic is on the axis it will show count of subscribers for all topics excluding the selected one.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team 

[v-sshirivolu]

Hi @PBI_AMS  ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solutionand give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.

[v-sshirivolu]

Hi @PBI_AMS ,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.