Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Distinct Count

 
zero % cont.png
hii 
I have 3 diiferent table in that project id is unique key ,for FTE one table (Headcount)anather is pdart which is main table which is having Active project and 3rd table is contribution in which having zero contribution project.i want project which having zero contribution and there fte from head count .
i want count of emp form headcount ,project id prom pdart,zero contribution from contribution table how can i arrange data or any other way ....
i want output as above table

1 REPLY 1
mehaboob557
Resolver IV
Resolver IV

Hi @Anonymous,

 

Can you please ecplain in detail so that we can help you.

 

Please take some sample tables as input and show what output you want. SO that we can understand and help you

 

Else,  share your sample pbix file

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.