Check if value exists in group

Question

Hello everyone!I need some help in case below:There are two tables A and B:And I would need to create an additional flag in dax (1/0) -&nbsp; if the LogGroup from table B contains LogKey = 124 then mark whole group as 1 (and therefore whole customer as 1) otherwise mark as 0The logic for this in SQL would be like:&nbsp;max( case when B.LogKey = 124 then 1 else 0 end ) OVER (PARTITION BY A.Customer) as Flag&nbsp;&nbsp;&nbsp;THANK YOU !&nbsp;

anonymous · Accepted Answer

Hi Attrywa&nbsp;,
&nbsp;
Please try:
&nbsp;
Create a calculated column in Table A:
Flag =
VAR CurrentGroup = 'Table A'[LogGroupKey]
VAR LogKeyCheck = CALCULATE(
     MAXX(
         RELATEDTABLE('Table B'),
         IF('Table B'[LogKey] = 124, 1, 0)
     ),
     FILTER(
         'Table B',
         'Table B'[LogGroupKey] = CurrentGroup
     )
)
RETURN IF(LogKeyCheck = 1, 1, 0)
&nbsp;
The page effect is as follows:

&nbsp;
pbix file is attached.
&nbsp;
If you have any further questions please feel free to contact me.
&nbsp;
Best Regards,YangCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!

Forum Discussion

Check if value exists in group

2 Replies

Related content

Check column for similar values

Check if a value exist in another column

Calculated column checking if value exists in another table

Check if a value exists previously

Check if a value exists in another table