Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
70 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |