Connecting the Slicer to Visual without affecting the measures

[Faris2024]

Spoiler

Spoiler

Hello everyone,

I would like to find a method to prevent the slicer from affectin the function of the measure I have created.

the highlighted measure includes a furmola to count a filtered coulmn from a table

the slicer added to another table to filter the data.

both tables are related but once that happens the measure in Card gets the same value.

This is the Card including the Measure highlighted:

This is the Measure I am applying to the highlighted Card:

This is the relation between the 2 tables I am using the Cost Center field in each table to connect:

I would appreciate your help

thank you

[v-denglli-msft · Accepted solution]

Thanks for the reply from powerbidev123, please allow me to provide another insight.

Hi @Faris2024 

You can try wrapping the table argument of the Filter function with an ALL function so that the filtering context returned by the Filter function is not affected by the external slicer.

Total_Below19=CALCULATE(
    COUNTROWS(Actual),
            FILTER(ALL(Actual),...)
)

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbidev123]

Hi @Faris2024 , To make this happen such that the slicer not affecting the measure inside the card visual. Go to Format-> Edit interactions .

Upon clicking the slicer you will symbol like this on top right corner of the visual .

It will stop the filtering on that particular visual. Let me know if this helps

[Faris2024]

Thank you @powerbidev123 for your helpful & unsightful information. However, What I need is to apply both the measure which includes filters and the slicer's filter.

[powerbidev123]

@Faris2024  .Try using KEEPFILTERS function or ALL function in your calculate measure. This will keep your filters intact

[Faris2024]

Did not work for me