Dynamic Cards by Selection on a Chart

Hi Jonny1541 ,

Thank you for reaching out to the Microsoft Community Forum.

For every selection in the funnel/drill hierarchy continues filtering the entire visual context, so all cards keep reacting to deeper selections. To get the desire result, each card should respond only to its own hierarchy level and deeper drill selections should be ignored for earlier cards.

Please try below steps.

1. Create Separate Measures Per Level.

Card 1 (Meter Type): This card should ONLY react to Meter Type.

Card 1 Meter Type =
CALCULATE(
SELECTEDVALUE(
'RG Removals'[Meter Type],
"All Meters"
),
REMOVEFILTERS(
'RG Removals'[Primary or Churn],
'RG Removals'[Comms Status],
'RG Removals'[IN_CONTRACT_FLAG],
'RG Removals'[IN_TERM_FLAG],
'RG Removals'[PROTECTED_FLAG],
'RG Removals'[Peppercorn_At_Removal],
'RG Removals'[CalisenAssetInstalled],
'RG Removals'[Outcome Category]
)
)

2. Card 2 should react to Meter Type and Primary or Churn. But ignore everything below.

Card 2 Primary or Churn =
CALCULATE(
SELECTEDVALUE(
'RG Removals'[Primary or Churn],
"All"
),

REMOVEFILTERS(
'RG Removals'[Comms Status],
'RG Removals'[IN_CONTRACT_FLAG],
'RG Removals'[IN_TERM_FLAG],
'RG Removals'[PROTECTED_FLAG],
'RG Removals'[Peppercorn_At_Removal],
'RG Removals'[CalisenAssetInstalled],
'RG Removals'[Outcome Category]
)
)

3. Each next card removes only lower-level filters.

Card 3 Comms Status =
CALCULATE(
SELECTEDVALUE(
'RG Removals'[Comms Status],
"All"
),

REMOVEFILTERS(
'RG Removals'[IN_CONTRACT_FLAG],
'RG Removals'[IN_TERM_FLAG],
'RG Removals'[PROTECTED_FLAG],
'RG Removals'[Peppercorn_At_Removal],
'RG Removals'[CalisenAssetInstalled],
'RG Removals'[Outcome Category]
)
)

Note: Please use above measures to get the desire result.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Thanks Dinesh, this has solved the problem.