Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Input Table
Output table
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.
Solved! Go to Solution.
@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:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi samarth, Thanks for replying. Is it possible for to generate a new table with above input table with the result.
@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:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thank you Samarth for both the logics. Both are correct and working fine.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |