Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This is my measure:
FTE Norm Timeloen = AVERAGEX (
VALUES ( DimDato[MånedÅr] ),
CALCULATE([Arbejds-timer i perioden] / 162.5 , FILTER(DimJob, DimJob[Ansættelsesform] = "Timelønnede"))
)
It works nicely for month in a year and also when I show for Year total:
december as an example works fine, so when I see the result 21.276 it adds up for the data when I extract to excel. When I show year only it gives me:
The 23.878 i currectly an average of hours 46561.6 for the year divided by 162.5
But here is the odd thing. When I extract the data. the FTE is higher:
When I add the FTE together it adds up to 38.65
Hos is that when the month is correct, the average FTE over year is correct, but the FTE when added is higher. What am I missing or is the measure not correct?
Solved! Go to Solution.
I figured it out.
It calculates correctly for each indivdual, and for the total it ofcourse caluculates for the total.
I figured it out.
It calculates correctly for each indivdual, and for the total it ofcourse caluculates for the total.
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
42 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |