Forum Discussion
Drill through using a filter
I have a line chart and each line got the following measures
Measure =
var a =calculate(counta(Student,[ID],Student[Status] = "A", Student[City] = "CA")
var b = calculate(counta(Student,[ID], Student[City] = "CA")
return
a/bThere are 6 other lines thats different for each city so the only change is this
Student[City] = "CA"
I created a new page for drill through that will have the StudentID,Status,City, State columns
and I add the measure to the table
but whenever I click on the drill through its still showing all the records and not filtering
Is there any workaround this?
2 Replies
Hi Mclovin100
Can you share the pbix that has the issue? Otherwise it is difficult to determine what the problem might be?
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Hi Mclovin100
You can try to change the Student[City] by using a slicer, the drill down cannot work may be affected by your measure filter,
if the suggestion can not meet your requirement, can you provide some sample picture?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
