Forum Discussion
DAX Measure
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
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
2 Replies
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