Hi,
I have used an online tutorial (https://youtu.be/gYbGNeYD4OY) to create an approach where my visual will display one of 4 different values based on a selected parameter using a slicer. This is working perfectly.
4 variations
# Completed Adults = CALCULATE(count('kcc FD_REQUEST_SUPPORT'[PersonID]),'kcc FD_REQUEST_SUPPORT'[Adult Child]="Adult")
# Completed Children = CALCULATE(count('kcc FD_REQUEST_SUPPORT'[PersonID]),'kcc FD_REQUEST_SUPPORT'[Adult Child]="Child")
# Completed People = CALCULATE(count('kcc FD_REQUEST_SUPPORT'[PersonID]))
# Completed Families = CALCULATE(DISTINCTCOUNT('kcc FD_REQUEST_SUPPORT'[Contact Group ID]))
I then have a DAX formula that is what I use in the visual
# Contacts Created = if(ISCROSSFILTERED(Parameters[Measure Type]),
SWITCH( TRUE(),
VALUES(Parameters[Measure Type]) = "All", [# Completed People],
VALUES(Parameters[Measure Type]) = "Families", [# Completed Families],
VALUES(Parameters[Measure Type]) = "Children", [# Completed Children],
VALUES(Parameters[Measure Type]) = "Adults", [# Completed Adults],
blank()),blank())
However, the issue I am having is when I try to drillthrough to see the data behind the numbers being generated above when either Adult or Child have been selected. It doesn't seem to push through the filter [Adult Child]="Adult") or [Adult Child]="Child") and therefore I am seeing the both adults and children in the listing. Can anyone offer any advice on how to pass filters that are part of a measure into a drillthrough? I have ticked the Keep All Filters option on the page that I am drilling through to but this hasn't resolved the issue.
Thanks
Chris
