Drill through using a filter

[Mclovin100]

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/b

There 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?

[Anonymous]

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.

[AlB]

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.