Forum Discussion
Lookupvalue from another table
Hi Anonymous ,
Please have a try.
Create a measure.
measure = VAR _1 = CALCULATE ( COUNT ( table2[month] ), FILTER ( ALL ( table1 ), table1[employee] = SELECTEDVALUE ( table2[employee] ) && table1[month] <> SELECTEDVALUE ( table2[month] ) ) ) RETURN IF ( _1 < 1, "No", "Yes" )How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, it worked! but where to add a another filter for date? Since in my table there is a month column. What happens is it marked as yes because it exists on the other table but that was for different month. Even if the table1 have the employee and doesnt exist on table2 for the month of November it is print yes.
Hi Anonymous ,
Please have a try.
Create a measure.
measure =
VAR _1 =
CALCULATE (
COUNT ( table2[month] ),
FILTER (
ALL ( table1 ),
table1[employee] = SELECTEDVALUE ( table2[employee] )
&& table1[month] <> SELECTEDVALUE ( table2[month] )
)
)
RETURN
IF ( _1 < 1, "No", "Yes" )
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It works but there are still some discrepancy with numbers. Thanks a lot! 🙂