Forum Discussion

AsifAnwar's avatar
AsifAnwar
New Member
4 years ago

Need help with Default Filtering on Multiple Columns

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

3 Replies

  • AsifAnwar's avatar
    AsifAnwar
    New Member
    4 years ago

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

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      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.