Power BI dax

[Anonymous]

I have two tables, one table have the employee data other table have the employee project details who are in live project or shadow or internal.suppose in employee table there 16 members among which only 10 people's data are  in project table as they are in project and their stautus is in progress. now 16-10=6 people are not in any project. i want to view those 6 people name. Note: we cant create duplicate table, calculated column

its has to be a measure .

Thanks In Advance

[Anonymous]

Hi Aditya,

Thanks for the solution it almost solved 90% of the problem, but here you have concatenated the names, i want the names to be returned so that i can count them and show them in table

[Anonymous · Accepted solution]

Hi @Anonymous ,
You can write a measure like this

Sample pbix file attached here.
Chaitali community.pbix

Regards,
Aditya

[Anonymous]

@amitchandak