Forum Discussion
Need help with Direct query tables and local tables when in limited relationship.
Hi Anonymous ,
Please try the steps below to get it:
1. Put the field [Need Help Recipients] of the table 'task' to replace the measure [NeeHelp_recp] on the visual
2. Create a measure as below to judge if the related mails fulfill the conditions
Flag = VAR _tab = CALCULATETABLE ( VALUES ( task[Need Help Recipients] ), FILTER ( task, task[Regarding] = Merge1[cmp_name.3] && task[Need Help Section] = Merge1[cmp_relevantsectionidname] ) ) RETURN IF ( SELECTEDVALUE ( task[Need Help Recipients] ), 1, 0 )3. Apply a visual-level filter with the condition (Flag is 1) on the below visual
Best regards
Hi, Thank you for the solution. It almost worked but i need all email id's as in a sperate row instead of concatenation.
Hi Anonymous ,
Please try the steps below to get it:
1. Put the field [Need Help Recipients] of the table 'task' to replace the measure [NeeHelp_recp] on the visual
2. Create a measure as below to judge if the related mails fulfill the conditions
Flag =
VAR _tab =
CALCULATETABLE (
VALUES ( task[Need Help Recipients] ),
FILTER (
task,
task[Regarding] = Merge1[cmp_name.3]
&& task[Need Help Section] = Merge1[cmp_relevantsectionidname]
)
)
RETURN
IF ( SELECTEDVALUE ( task[Need Help Recipients] ), 1, 0 )3. Apply a visual-level filter with the condition (Flag is 1) on the below visual
Best regards