DAX rollup hierarchy

[Anonymous]

Hi,

The dax measure I need help with is "Driver Active Days". It returns the values correctly at the fiscal period level; however, it's wrong when it rolls up to the fiscal year level. The fiscal year 2019 should return a value of 1743, not 2431. Can anyone help tweak it please? Thank you.

The data model looks like this:

The PBIX files can be downloaded here 

[amitchandak]

@Anonymous , Change return like this and try

Sumx(Addcolumns( summarize( FactEmployeeHistory, DimDate[Year], DimDate[Period]), "_1", IF(NOT(ISBLANK([Driver working Hours])), days)),[_1])

[teresating886]

@amitchandak It doesn't work because there is no relationship between FactEmployeeHistory and DimDate.