Filter on a slicer, based on a selected value in a parameter

[biancakarremans]

Hi all,

We use parameters in our report. Those parameters are filled with measures that have filters in them, beneath an example of a calculated column which forms the base of one of those measures.

IF(

    RELATED('DM_CONFORM DIM_ZAAK'[Zaaktype code]) = "fictional code" &&

    RELATED('DM_CONFORM DIM_PRODUCT'[Product code]) = "fictional code" &&

    NOT(RELATED('DM_CONFORM DIM_ZAAK'[Zaakresultaat]) IN {"fictional code"}),

1, 0)

The slicer shows all values that are possible in the 'Zaaktype code'. When selecting the parameter field that contains the filters above we want those filter options to be the only ones showing in the slicer. 

If anyone has suggestions, please let us know

[Ritaf1983]

Hi @biancakarremans 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly