Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hello @Himanshu_1306 ,
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
Hello @Himanshu_1306 ,
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
Yes my bad, got the desired result.
Regards
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |