Syntax error when using calculate function with multiple filters

[ce138867]

I am trying to create a measure with the following formula

Measure1= CALCULATE(

    DISTINCTCOUNT('Baseline'[FIN]),FILTER('Baseline',[Episode Trigger Status]= "Post-Trigger"}

&& 'Baseline',Baseline[Encounter Type] = "IP"))

The error displayed is: The syntax for '}' is incorrect. (DAX(CALCULATE( DISTINCTCOUNT('Baseline'[FIN]),FILTER('Baseline',[Episode Trigger Status]= "Post-Trigger Encounter"}&& 'Baseline',Baseline[Encounter Type] = "101 - Inpatient")))).

Any suggestions?

[Anonymous · Accepted solution]

@ce138867 Try This:

 Measure1= CALCULATE(
    DISTINCTCOUNT('Baseline'[FIN]),FILTER('Baseline',AND([Episode Trigger Status]= "Post-Trigger",Baseline[Encounter Type] = "IP")))

[ce138867]

Thanks @Anonymous, that worked like a charm!

[Anonymous]

@ce138867 

Measure1= CALCULATE(
    DISTINCTCOUNT('Baseline'[FIN]),FILTER('Baseline',AND([Episode Trigger Status]= "Post-Trigger",Baseline[Encounter Type] = "IP")))

[ce138867]

NVM, I saw that I had a "}" that I needed to delete. With that removed, I now get the error: Too many arguments were passed to the FILTER function. The maximum argument count for the function is 2.

[vpanchu]

@ce138867 

Try This

CALCULATE(

    DISTINCTCOUNT(

        'Baseline'[FIN]

        ),

       FILTER('Baseline',

       [Episode Trigger Status]= "Post-Trigger Encounter"

      &&

     'Baseline',Baseline[Encounter Type] = "101 - Inpatient"

     )

)

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!