Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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(PRODU...
Need Help
  • jpessoa8's avatar
    jpessoa8
    2 years ago

    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

jpessoa8's avatar
jpessoa8
Continued Contributor
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes my bad, got the desired result.

    Regards