Mesaure is not summering the total right

[Moller70]

Hi.

I have the following mesaure in Power BI:

XYC earned vacation days =

Var VacationDaysHoleYear = if([XYC Total Experiance and education]> 10, 26,20)  // detmining how manye vacation days a year depending on total calculatet experiance and education

Var VacStartDato = max(MAXX('XYC Employee','XYC Employee'[LatestStartDate]),STARTOFYEAR(Kalender[Date])) //Start of the year, or in case of employment during the year the employment date

Var VacStopDato = Min(

    If(MAXX('XYC Employee','XYC Employee'[LatestStopDate])<STARTOFYEAR(Kalender[Date]),ENDOFMONTH(Kalender[Date])),ENDOFMONTH(Kalender[Date])) //End of month, or in case of a stop date during the year, then stop date

Var NumberOfMonths = DATEDIFF(VacStartDato,VacStopDato,MONTH)+1 // calculating the number of months in the year

Return

ROUNDUP(VacationDaysHoleYear/12*NumberOfMonths,0) // calculating how many vacation days earned for the year

It is calculation correct for each employee but not in total.

Can anyone help?

[Greg_Deckler]

@Moller70 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[Moller70]

@Greg_Deckler  thank you for your reply.
Now I have changede my mesaure to:

XYC earned vacation days =

Var VacationDaysHoleYear = if([XYC Total Experiance and education]> 10, 26,20)  // detmining how manye vacation days a year depending on total calculatet experiance and education

Var VacStartDato = max(MAXX('XYC Employee','XYC Employee'[LatestStartDate]),STARTOFYEAR(Kalender[Date])) //Start of the year, or in case of employment during the year the employment date

Var VacStopDato = Min(

    If(MAXX('XYC Employee','XYC Employee'[LatestStopDate])<STARTOFYEAR(Kalender[Date]),ENDOFMONTH(Kalender[Date])),ENDOFMONTH(Kalender[Date])) //End of month, or in case of a stop date during the year, then stop date

Var NumberOfMonths = DATEDIFF(VacStartDato,VacStopDato,MONTH)+1 // calculating the number of months in the year

Var m_Single = ROUNDUP(VacationDaysHoleYear/12*NumberOfMonths,0) // calculating how many vacation days earned for the year

Var _table = SUMMARIZE('XYC Employee','XYC Employee'[Employeeno],"_value",m_Single)

Return

If(HASONEVALUE('XYC Employee'[Employeeno]),m_Single,sumx(_table,[_value]))

But this is now showing a total of 18, but I shall be 25. And in a chart is is showing 48. So now I am confused.

 My old measure is showing 3 i both the tabel and chart, but it should be 25.

@Greg_Deckler do you have any suggestions?