Dax Help

[Anonymous]

Sorry all , this question is related to my other issue but I have select solved and I cant undo it 

@themistoklisThanks , error gone, cheers

@themistoklis the error is gone but I just came a cross another issue/error:

this above meaure uses multiple measures from other datasets

and on my other meaure which returen stings value I am using 

PR = CALCULLATE(SUM(viewName[pq) = "N"]

this is string and I belive cant use CAL SUM?

what would I use ?

and 

 PR = CALCULATE(COUNT(viewName[A]),viewName[P]) ="N"

first value is numver and second is string 

thanks 

[themistoklis]

@Anonymous

Your formula has syntax errors. Can you try the following:

CALCULATE(COUNT(viewName[A]),viewName[P] = "N")

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try below measure:

PR =
CALCULATE ( COUNT ( viewName[A] ), FILTER ( viewName, viewName[P] = "N" ) )

Regards,

Cherie

[Anonymous]

Thanks all for your help