How to hide specific calculation items in a slicer regarding the selection of another slicer

[Anonymous]

I have 2 slicers on my dashboard to  control a graphic: 

-the first one to be selected is about the customer status: if he has a customer card or no. It is based on a calculation group.

-the second slicer is a KPI slicer (revenue, buyer, aov...) and it´s also based on another calculation group: regarding the customer status, I have different metrics.(switch function) 

My problem is: I want specific KPIs to disappear from the second slicer when we select the status: "no customer card" in the first slicer.(in my case for example the buyer KPI should not be shown in the second slicer, only revenue and aov)

I didn´t find any clue, I only get to put a BLANK() in the switch metric of the second clicer so that no result are being showed in the final graphic if we select: no-customer card and buyers. But it would be nicer just no to show the buyer KPI in the slicer otherwise are my clients wondering what´s going on....

Thanks for your help!

[DataInsights · Accepted solution]

@Anonymous,

I was able to adapt the creative solution in the blog post below (kudos to the author!).

https://sqlitybi.com/how-to-filter-calculation-group-with-another-table-or-dimension/ 

1. Create a table named Slicers. This table defines the valid combinations of Customer Status and KPI. Each slicer will be based on this table. This table has no relationships.

2. Create a calculation group CalcGroupKPI with a calculation item for each measure you want to use. Example: the AOV calculation item would reference the measure [AOV].

3. Create the measure [Metric] and add to a visual:

Metric = 
CALCULATE (
    SELECTEDMEASURE (),
    CalcGroupKPI[KPI] = SELECTEDVALUE ( Slicers[KPI] )
)

4. Result:

---

[Anonymous]

Hi @DataInsights 

it is working but I´m still not sure how excatly.

You didn´t mentioned how you filtered the visual with the metric.

I put the condition: contains 1 or contains 2.

And it´s working.

Thanks

[DataInsights]

@Anonymous,

The visual should automatically be filtered by the Metric measure and the KPI slicer. Do you have interactions enabled between the KPI slicer and visual? Interactions between the Customer Status slicer and the visual have no impact.