Forum Discussion
complex slicer question
Community ChampionSeems to me that you want some sort of measure calculation that adjusts how the slicer is used to filter by overriding it in certain circumstances. If and how exactly that would work can't really be determined from the information presented. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sorry, I realise that wasn't clear, let me explain it by taking a different approach.
So I have my Activity data ('UV for Rapidminer (Machine Gen)') containing user IDs and sectors. I have a row for every single time a user has viewed a sector.
I also have my Demographic data ('Distinct IDs') containing the user IDs and personal information (age, income etc).
The two tables are connected via the user IDs.
I have a user ID slicer and I want to show how many people other than the selected user viewed the same sectors as the selected user.
So I wrote a measure that counts all the distinct user IDs in the activity data EXCEPT the one selected in the slicer:
If I put this into, let's say, a matrix, the issue is that I now get all the sectors listed, even the ones that weren't viewed by the selected user.
Let me explain what I mean.
In this example the selected user, user 3, has never viewed 'Utilities' as you can see below (it's missing from the list):
However, once I add the User count all the sectors appear in the visual, even 'Utilities':
My goal is essentially to get a table that shows the exact same values as the one above but without 'Utilities' as that is not something that was viewed by the user selected in the slicer.
I hope this makes sense.