Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bokazoit
Post Patron
Post Patron

Wierd measure calcualtion when exporting data

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:

Bokazoit_0-1676641190271.png

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:

 

Bokazoit_1-1676641349464.png

The 23.878 i currectly an average of hours 46561.6 for the year divided by 162.5

Bokazoit_2-1676641448695.png

But here is the odd thing. When I extract the data. the FTE is higher:

Bokazoit_3-1676641615191.png

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?

1 ACCEPTED SOLUTION
Bokazoit
Post Patron
Post Patron

I figured it out.

It calculates correctly for each indivdual, and for the total it ofcourse caluculates for the total. 

View solution in original post

2 REPLIES 2
Bokazoit
Post Patron
Post Patron

I figured it out.

It calculates correctly for each indivdual, and for the total it ofcourse caluculates for the total. 

lbendlin
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors