Measure works now want to define which values it uses

[WDHB01]

This measure works

DNA = COUNTROWS(FILTER('pas tbl_OPAppt',CONTAINS('pas tbl_OPSMSSent','pas tbl_OPSMSSent'[EncounterNumber],'pas tbl_OPAppt'[EncounterNumber])))

But want to specify that the value in ActivityStatus column in the pas tbl_OPAppt', table = 'DNA

Any help appreciated.

[pranit828]

Hi @WDHB01 

Try

DNA = CALCULATE(COUNTROWS('pas tbl_OPAppt'),FILTER('pas tbl_OPAppt',CONTAINS('pas tbl_OPSMSSent','pas tbl_OPSMSSent'[EncounterNumber],'pas tbl_OPAppt'[EncounterNumber])) && 'pas tbl_OPAppt'[ActivityStatus]= 'DNA')

[WDHB01]

Hi Pranit, thanks for the reply.

I received this error.

The syntax for '' '' is incorrect. (DAX(COUNTROWS(FILTER('pas tbl_OPAppt',CONTAINS('pas tbl_OPSMSSent','pas tbl_OPSMSSent'[EncounterNumber],'pas tbl_OPAppt'[EncounterNumber]))&& 'pas tbl_OPAppt'[ActivityStatus]' 'DNA'))).

[WDHB01]

I hadn't copied the measure correctly. Fixed that but now I get this error.
A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

[WDHB01 · Accepted solution]

I have fixed my problem this is the solution...

DNA = CALCULATE(COUNTROWS('pas tbl_OPAppt'),FILTER('pas tbl_OPAppt',CONTAINS('pas tbl_OPSMSSent','pas tbl_OPSMSSent'[EncounterNumber],'pas tbl_OPAppt'[EncounterNumber])), filter(all('pas tbl_OPAppt'), 'pas tbl_OPAppt'[ActivityStatus]= "DNA"))

[WDHB01]

Hi Pranit, thanks for the reply.

I received this error.

A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.