DAX Measure

[Anonymous]

Hi All,

I'm trying to write a DAX measure like below and getting error.

Any help on this?

Scenario : If SE_COUNT = 1 then I want it to do sum(SE_ACV) otherwise is SE_Count = 0 then sum(PRODUCT_ACV)

Should I use SWITCH function instead of IF?

Regards

[jpessoa8 · Accepted solution]

Hello @Anonymous ,

The error you're getting is because of misplacing of parenthesis. You must close the parenthesis after stating the column in the MAX function, not after the " = 1" part.

Product_ACV_SE = 
IF( 
	MAX(VW_F_SE_ATTRIBUTION[SE_COUNT]) = 1, 
	SUM(VW_F_SE_ATTRIBUTION[SE_ACV]), 
	SUM(VW_F_SE_ATTRIBUTION[PRODUCT_ACV])
)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Jorge Pessoa

[Anonymous]

Yes my bad, got the desired result.

Regards