Finding drill down/up level

[User12345432334]

Hello.

I have a clustered column chart. For my X-axis, I have 2 columns Week and Day with values like ("2024 W10", "01/01/2024"), and for my Y-axis I have a count of tickets.

The graphic is this:

I added 2 Constant Lines with values 482 and 123 (Thresholds). 

I need to do the following thing: 

if the user is on weekly level, like in the picture above, the thresholds should remain the same, but if the user drills down on daily level, the threshold should be 482 divided by 7 and 123 divided by 7.

Is there a way I can get the level from the graphic in a measure or what are my options to display the threshold dynamically based on drill down/up level?

Thanks in advance!

[MFelix]

Hi @User12345432334 ,

The constant lines don't have the context of the calendar since they are for the full dates I would add this in the lines of a line and clustered column chart and would create two measures similar to these:

Max Threshold= IF(ISINSCOPE('Calendar'[Date]), 482/7 , 482)

Min Threshold= IF(ISINSCOPE('Calendar'[Date]), 123/7 , 123)

Now use this measurds on the Line Y-axis and don't forget to align zeros and turn of values of secondary y-axis.