Forum Discussion
Solved
SUMMARIZE, SUMX not working as expected
Hi, my DAX ... Position_Headcount = VAR Helper_Table = SUMMARIZE('FACT_turnover',FACT_turnover[Position],"Helper_Value",[Position_HeadCount_1]) RETURN IF(HASONEVALUE(Fact_turnover[Positi...
... more specific, this DAX works, gives me the correct Total:
Position_Headcount =VAR turnover_position = SELECTEDVALUE(FACT_turnover[Position])VAR Helper_Table = ADDCOLUMNS( SUMMARIZE('FACT_turnover',[Position],"Helper_Position", turnover_position), "Helper_Count", [Position_HeadCount_1])RETURNIF(HASONEVALUE(Fact_turnover[Position]),[Position_HeadCount_1],SUMX(Helper_Table, [Helper_Count]))
... sorry folks, should have searched before.
The answer is here
... more specific, this DAX works, gives me the correct Total:
Position_Headcount =
VAR turnover_position = SELECTEDVALUE(FACT_turnover[Position])
VAR Helper_Table = ADDCOLUMNS( SUMMARIZE('FACT_turnover',[Position],"Helper_Position", turnover_position), "Helper_Count", [Position_HeadCount_1])
RETURN
IF(HASONEVALUE(Fact_turnover[Position]),[Position_HeadCount_1],SUMX(Helper_Table, [Helper_Count]))