DAX Calculated Field - Filter / Sum formula Error.

[countryfan_nt]

Hello friends, Hope all is well!

Please help me fix the calculated field here: =CALCULATE(sum('Avg Claim CSV'[Total Visit],'Avg Claim CSV' [InvoiceType] = "OutPatient"))
I am trying to sum Total Visit of OutPatient only.

Thank you so much in advance!

 

[RoryA]

It looks like you have a bracket in the wrong place to me:

=CALCULATE(sum('Avg Claim CSV'[Total Visit]),'Avg Claim CSV' [InvoiceType] = "OutPatient")​

 

[countryfan_nt]

thank you, I copied your formula, and got a new error:
The expression is not valid or appears to be incomplete. Please review and correct the expression.
The following syntax error occurred during parsing: Invalid token, Line 1, Offset 90, .

 

[RoryA]

It works fine for me.