Forum Discussion

mizaskun's avatar
mizaskun
Icon for Helper II rankHelper II
5 years ago

DAX subtotal sum

Good afternoon,   I am having problems trying to come up with a subtotal.   I have the following measure: M_IMPACTO_ECONOMICO = calculate([M_IMPACTO_FINAL], VALORACIONES[IMPACT_CAT] = "00...
DAX
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

Yeah... Writing DAX the way you do... is a sure way to not understand what it does. DAX which is not correctly formatted is not DAX. Rules for DAX Code Formatting - SQLBI


By the way, using nested IF's is not elegant. There's a better way: SWITCH.

 

After two days nobody has even tried to reply to your post. Guess why.