Line chart percentage measure working with a drill-down dimension

[davehutchinson]

Hi all.  I've got a line chart that measures usage % by code on a day by day basis.

I've recently been given access to a more detailed breakdown of usage by hour.  So I've created a drill down and inserted that into my dimension.

However the % usage doesn't change the dimension when you drill down.

I have created the drill down dimension and called is "Week_Date_Hour Drill Down".  This works, on the chart but the percentages are always based on the day, when I want them to be base on the hour/week etc depending on what you're looking at. 

So I presume the issue must be with the Measure as this currently mentions:

total<Test_Date> to base the total on.

My measure is:

Count({<[test_category]={"8005"},[consumer_outcome_code]-={"OD705NGD"},[Service_Type]={"FTTP"}>}Consumer_Outcome_Prefix)
/
Count(total<Test_Date>{<[test_category]={"8005"},[consumer_outcome_code]-={"OD705NGD"},[Service_Type]={"FTTP"}>}[circuit_id])

I was thinking there must be a way to insert the "Week_Date_Hour Drill Down" master item into this measure, instead of <Test_Date> but can't find anyway to do this.  Can anyone help me?

[Camilla84]

Hi, @davehutchinson 
Have you tried create a straight table with all this fields and filter same values you need for your line chart to see what it shows? 

[Kushal_Chawda · Accepted solution]

@davehutchinson  include all the drill down dimensions in total

Count(total<Test_Date,Test_week,Test_hour>{<[test_category]={"8005"},[consumer_outcome_code]-={"OD705NGD"},[Service_Type]={"FTTP"}>}[circuit_id])

[davehutchinson]

Thank you!!! That's amazing! That has done the trick!