The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Hi @Anonymous ,
You can write a measure like this
Sample pbix file attached here.
Chaitali community.pbix
Regards,
Aditya
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
Hi @Anonymous ,
You can write a measure like this
Sample pbix file attached here.
Chaitali community.pbix
Regards,
Aditya
@amitchandak
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
10 | |
7 |