Calculate sum FTE distinct user

[Itzarthi]

Hey Guys!

I'm trying to calculate the FTE, but i dont know how to summarize it, because my employees have different contracts. In this example I want to see the summed value of 3,9 in a card in Power BI (Based on the last startdate). How can I realize that? 

I tried FTE's = calculate(SUM('Contracten V2'[FTE]), distinctcount('Contracten v2'[EMPLOYEEID])) but this don't work.

I hope you guys can help me out!

[amitchandak]

@Itzarthi , You want like

calculate(SUMX(values('Contracten V2'[FTE]), distinctcount(Contracten[EMPLOYEEID])))

or

SUMX(values( Contracten[EMPLOYEEID]), calculate(sum( 'Contracten V2'[FTE])))

[Itzarthi]

@amitchandak Thank you for  your formula but it isn't working..

[amitchandak · Accepted solution]

@Itzarthi , Try like

SUMX(values( Contracten[EMPLOYEEID]), calculate(max( 'Contracten V2'[FTE])))

[Anonymous]

This is most helpful! I am getting a total sum of all FTE across each line item, is there a way to determine the actual FTE over months in years?