Dear All,
I have a problem with one of my drillthrough solutions. We have a list of clients, and we would like to checking who were contacted by salesperson and on what kind of Channels (phone, email, etc.).
Also one of my matrix visuals contains two columns with "Contacted" and "Not Contacted" columns (here I use a measure with SWITCH as value, when header is "Contacted" then use measure for contacted clients, when "Not Contacted" then use an other measure for not contacted clients :
- in column "Contacted" there are some clients who were contacted by salesperson (distinctcount of ClientsID filetered on contacted status: CALCULATE(DISTINCTCOUNT(ClientsID),FILTER(table,table[Contacted]=1)), also here we can filter on Channels.
- the column "Not Contacted" is trickier: here I have to show all other clients indepently from channels, also I tried to use a simple subtraction: CALCULATE(DISTINCTCOUNT(ClientsID),ALL(table[Channels)) - "Contacted Clients"
And problem is coming at this point, because I would like to drillthrough to an other page where is a list of clients. Everything work well until I filter on contacted clients, but when I try to drill through on not contacted clients, and a channel is selected, then I don't see anything in this list.
It seems to me, issue is, when I select a channel it will be validated all the time, when I use the drillthrough, also in case of not Contacted clients it makes a empty sets of data (because who is not contacted or contacted but not on the selected channel will be filtered out in this case).
Also question, how can I solve, that drillthroughing on not contacted column it shows something in the list? Maybe can I create a measure which reverse filtering in case of not contacted items?
All advice is welcome!:)
