Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX rollup hierarchy

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 ye...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
teresating886
Frequent Visitor
4 years ago

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