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"))
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, WDHB01 
The formula needs a small change：

 

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

 

If it doesn't meet your requirement,please share  your sample data for futher research.

 

Best Regards,
Community Support Team _ Eason

WDHB01's avatar
WDHB01
Helper I
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"))