Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax Help

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 

  • Hi Anonymous

     

    You may try below measure:

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

    Regards,

    Cherie

3 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee

    Hi Anonymous

     

    You may try below measure:

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

    Regards,

    Cherie

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks all for your help

  • themistoklis's avatar
    themistoklis
    Community Champion

    Anonymous

     

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

     

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