topic Re: Connecting the Slicer to Visual without affecting the measures in DAX Commands and Tips

Connecting the Slicer to Visual without affecting the measures

Faris2024 — Tue, 03 Dec 2024 07:19:26 GMT

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

Re: Connecting the Slicer to Visual without affecting the measures

powerbidev123 — Tue, 03 Dec 2024 07:39:29 GMT

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

Re: Connecting the Slicer to Visual without affecting the measures

Faris2024 — Tue, 03 Dec 2024 07:44:34 GMT

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.

Re: Connecting the Slicer to Visual without affecting the measures

powerbidev123 — Tue, 03 Dec 2024 07:51:29 GMT

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

Re: Connecting the Slicer to Visual without affecting the measures

Faris2024 — Tue, 03 Dec 2024 09:54:50 GMT

Did not work for me

Re: Connecting the Slicer to Visual without affecting the measures

Anonymous — Wed, 04 Dec 2024 06:00:10 GMT

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.