topic Re: Need help with Default Filtering on Multiple Columns in DAX Commands and Tips

Need help with Default Filtering on Multiple Columns

AsifAnwar — Wed, 16 Feb 2022 23:57:34 GMT

Hi, need some help with deffault filtering. I have table, and what i want is to filter a specific variable from each column and then use it to display the result in a "card". the users will be able to use the slicer to filter through the data, and if they hit the reset button, it will again default back to the filtered results.

the table looks like this:

What i want is to measure the No. of Participants by displaying the default value when
State="ALL", District="ALL", DisabilityGroup="ALL", AgeRange="ALL", SuppClass="ALL"

This will be default card value. The users will have the option to use the slicer and disect the results by whatever way they want.

Is it possible? How can i do it?

I am new to PowerBI and would love a detailed explanation on how to solve this.

Thanks.
Asif

Re: Need help with Default Filtering on Multiple Columns

amitchandak — Thu, 17 Feb 2022 04:04:31 GMT

AsifAnwar , You can create a bookmark with all that can allow you reset it will. All other slicer show work as usual

https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story

Your clear position is all selected in slicers

Re: Need help with Default Filtering on Multiple Columns

AsifAnwar — Thu, 17 Feb 2022 23:09:25 GMT

i was hoping to get a solution using Dax. is there? or is bookmark the only option i got?

Re: Need help with Default Filtering on Multiple Columns

v-yanjiang-msft — Tue, 22 Feb 2022 07:14:00 GMT

Hi AsifAnwar ,

By my test, can't achieve it by DAX, as the selected value in slicer does not change unless reselected.

I'm afraid you can only get it by bookmark.

Best Regards,
Community Support Team _ kalyj

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