Forum Discussion
Solved
Filter out rows in a table using a button or toggle
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 i...
TheV500Oshin Here is the sample file with the solution https://www.dropbox.com/t/zcapitgXbnBiz4nX
The report looks like this
This is the measure codeMeasure = 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 ResultPlease let me know if this answers your query or if you need any further modifications.
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.
Two buttons are ok ( Yes, No ) or you need only one ( Yes )?
Two buttons is fine thank you
TheV500Oshin Here is the sample file with the solution https://www.dropbox.com/t/zcapitgXbnBiz4nX
The report looks like this
This is the measure codeMeasure = 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 ResultPlease let me know if this answers your query or if you need any further modifications.