DAX showing error!

[Anonymous]

Hello,

I am trying to write the dax as below:

DIVIDE(CALCULATE(SUM(DE_C[TOTAL]),DE_C[RESPONSE] = "A"),CALCULATE(SUM(DE_C[TOTAL]),DE_C[RESPONSE] IN{"A","D","U"},0))

but pbi is showing me the below error:

Can somebody please help me. 

[Smalfly]

Hi @Anonymous ,

please try this:

DIVIDE(CALCULATE(SUM(DE_C[TOTAL]),DE_C[RESPONSE] = "A"),CALCULATE(SUM(DE_C[TOTAL]),DE_C[RESPONSE] IN{"A","D","U"}),0)

It is most likely due to a misplaced closing bracket for the calculate function in the denominator.

[Anonymous]

please give a sample data example in an excel sheet and also say what do you expect as an output so that i can help you

[otravers]

There's another forum for DAX questions, this one is about the Power BI service.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands