Partition By in Measure Expression / And Filter Operation within an Attribute
We have a unique requirement, following is an example table
We have other tables as well and the only measure we use is Count(Distinct Subscribers).
The requirement is that when user selects two persona, only subscribers belonging to both of these personas should be considered. i.e. if the user selects Persona = 'Foodie' & 'Traveler' then from the above example only subscriber '1' should be considered in Count(Distinct Subscribers) rather than both 1 & 2.
Currently what happens is that both 1 & 2 will be considered because both of them have Foodie. But only one have Traveler.
The number of selections can be upto 100 so we can't have them in different columns. It has to be in the same column.
What I need is something like this
if Total Count(Distinct Persona) = Count(Distinct Persona) over (partition by Subscriber)