topic Re: Filter out rows in a table using a button or toggle in DAX Commands and Tips

Filter out rows in a table using a button or toggle

TheV500Oshin — Wed, 23 Feb 2022 10:34:49 GMT

Hello

I need a way of a button/toggle to filter out rows based on a string.

I have created a small table with the fields "Yes" or "No" and I need to filter a table depending on which button is pressed.

For example I have a field called JobTitle and if I press "Yes" I need to show all the rows that doesn't contain "CEO" and when I untick "Yes" I need to return all the fields back that does contain "CEO".

I don't want to use bookmarks but if there is another way of doing this that would be great.

Thanks

Oshin

Re: Filter out rows in a table using a button or toggle

Samarth_18 — Wed, 23 Feb 2022 10:46:53 GMT

Hi TheV500Oshin ,

You can create a bookmark with filter then add a button and put bookmark as action for your button.

Thanks,

Samarth

Re: Filter out rows in a table using a button or toggle

TheV500Oshin — Wed, 23 Feb 2022 10:48:19 GMT

Is there anyway of doing this without bookmarks?

Re: Filter out rows in a table using a button or toggle

Samarth_18 — Wed, 23 Feb 2022 10:54:21 GMT

TheV500Oshin Create two pages one with filter and another with without filter and put button action as navigation to other page. Mark newly created page as hidden so user will not see in services.

Re: Filter out rows in a table using a button or toggle

tamerj1 — Wed, 23 Feb 2022 11:45:04 GMT

Hi TheV500Oshin
Can share some screen shots of what your data looks like and what exactly you want to filter?

Thankl you

Re: Filter out rows in a table using a button or toggle

TheV500Oshin — Wed, 23 Feb 2022 11:47:34 GMT

Hello,

I cannot share screenshot as it sensitive data. I need to be able to filter out the string "CEO" from a column called Jobtitle but it has to be using a toggle for the user.

Re: Filter out rows in a table using a button or toggle

tamerj1 — Wed, 23 Feb 2022 12:09:02 GMT

Two buttons are ok ( Yes, No ) or you need only one ( Yes )?

Re: Filter out rows in a table using a button or toggle

TheV500Oshin — Wed, 23 Feb 2022 12:16:05 GMT

Two buttons is fine thank you

Re: Filter out rows in a table using a button or toggle

tamerj1 — Wed, 23 Feb 2022 12:52:56 GMT

TheV500Oshin Here is the sample file with the solution https://www.dropbox.com/t/zcapitgXbnBiz4nX
The report looks like this
This is the measure code

Measure = VAR Selection = IF ( ISFILTERED ('Is CEO'[CEO?] ), CALCULATE ( VALUES ( Employees[Jobtitle] ), Employees[Jobtitle] = "CEO" ), CALCULATE ( VALUES ( Employees[Jobtitle] ), Employees[Jobtitle] <> "CEO" ) ) VAR Result = IF ( HASONEVALUE ( Employees[EMPID] ), Selection ) RETURN Result

Please let me know if this answers your query or if you need any further modifications.