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
- v-xiaosun-msft
Community Support
Hi MoodyDirk ,
Glad that you have solved the problem by yourself! If you don't have other problems, could you please accept your answer as the solution? Then we are able to close the thread.
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
... 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]))
