Posts: 66
Registered: ‎12-07-2017

Distinct Count

zero % cont.png
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

Posts: 117
Registered: ‎08-01-2017

Re: Distinct Count

Hi @Poojad1,


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