Distinct Count

[Anonymous]

 

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

[mehaboob557]

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