Forum Discussion

WDHB01's avatar
WDHB01
Helper I
5 years ago
Solved

DAX beginners question

Created this measure based on the formula below but no data is returned. The MessageStatusCode field is varchar not numeric which is why I used VALUE "TotalTxts2 = CALCULATE( COUNTROWS('pas tbl_OP...
Need Help
  • WDHB01's avatar
    WDHB01
    5 years ago

    Thanks for reply, I posted again as wasn't getting any replies and got the solution I needed.

    TotalTxts2 = CALCULATE( COUNTROWS('pas tbl_OPSMSSent'),FILTER('pas tbl_OPSMSSent',trim('pas tbl_OPSMSSent'[MessageStatusCode])="0"))
Fowmy's avatar
Fowmy
Super User
5 years ago

WDHB01 

 

What's your question here?

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 

  • WDHB01's avatar
    WDHB01
    Helper I
    5 years ago

    It should return a count of all rows that have a column value of "0"

    [MessageStatusCode] = "0"
    • Fowmy's avatar
      Fowmy
      Super User
      5 years ago

      WDHB01 

      Try this please:

      TotalTxts2 = 
CALCULATE( 
    COUNTROWS('pas tbl_OPSMSSent'), 
    'pas tbl_OPSMSSent'[MessageStatusCode] = 0 
)

      ________________________

      If my answer was helpful, please consider Accept it as the solution to help the other members find it

      Click on the Thumbs-Up icon if you like this reply 🙂

      YouTube  LinkedIn

      • WDHB01's avatar
        WDHB01
        Helper I
        5 years ago

        Thanks for the reply.

         

        Get error message.

        Error Message:

        MdxScript(Model) (4, 84) Calculation error in measure 'pas tbl_OPSMSSent'[TotalTxtsSent]: DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.