Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@Itzarthi , Try like
SUMX(values( Contracten[EMPLOYEEID]), calculate(max( 'Contracten V2'[FTE])))
@Itzarthi , You want like
calculate(SUMX(values('Contracten V2'[FTE]), distinctcount(Contracten[EMPLOYEEID])))
or
SUMX(values( Contracten[EMPLOYEEID]), calculate(sum( 'Contracten V2'[FTE])))
@Itzarthi , Try like
SUMX(values( Contracten[EMPLOYEEID]), calculate(max( 'Contracten V2'[FTE])))
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |