Remove / Hide field from chart during drill down

[Anonymous]

Hi,

Chart-Line & Clustered Column Chart
X axis : month, week,date {3 fields are present to create hierarchy}
Y axis : Amount, Avg price{2 measures are present, these 2 bars are side to side}
Line y axis :A line field is present

Question- I want to  remove or hide the avg price measure when chart is drilldowned to week or date level. How can I do this?
Thanks in advance!!

[Vignesh_Nagaraj]

ExcludeWeekLevelHierarchy =
SWITCH(
TRUE(),
ISINSCOPE('month'[month]), SUM('Amount'[Amount]),
ISINSCOPE('week'[week]), BLANK()
)

[lbendlin]

Learn about ISINSCOPE.  Return BLANK() in the measure when week or date is in scope.