topic Re: Perform filtering on column value based on condition in DAX Commands and Tips

Perform filtering on column value based on condition

Anonymous — Thu, 17 Mar 2022 05:30:24 GMT

I have a table where i need to filter a team when it has both requestor and superuser for each CR No. Eg;- CR 130 has both Requestor and superuser so it is present in my output table. CR 128 has only superuser so its not present in my output table.What should i do to get output table.

Re: Perform filtering on column value based on condition

Samarth_18 — Thu, 17 Mar 2022 05:43:50 GMT

Hi Anonymous ,

Create a measure like below and use it as filter on your visual:-

Measure = COUNTROWS ( FILTER ( 'Table', CALCULATETABLE ( VALUES ( 'Table'[CR NO] ), 'Table'[Team] = "Superuser" ) && CALCULATETABLE ( VALUES ( 'Table'[CR NO] ), 'Table'[Team] = "Requestor" ) ) )

Output:-

Thanks,

Samarth

Re: Perform filtering on column value based on condition

Anonymous — Thu, 17 Mar 2022 08:58:56 GMT

Hi samarth, Thanks for replying. Is it possible for to generate a new table with above input table with the result.

Re: Perform filtering on column value based on condition

Samarth_18 — Thu, 17 Mar 2022 09:48:00 GMT

Anonymous , Try this for table:-

Table 2 = SUMMARIZE ( FILTER ( 'Table', CALCULATETABLE ( VALUES ( 'Table'[CR NO] ), 'Table'[Team] = "Superuser" ) && CALCULATETABLE ( VALUES ( 'Table'[CR NO] ), 'Table'[Team] = "Requestor" ) ), 'Table'[CR NO],'Table'[Team] )

Output:-

Re: Perform filtering on column value based on condition

Anonymous — Thu, 17 Mar 2022 11:15:17 GMT

Thank you Samarth for both the logics. Both are correct and working fine.