topic Re: SUM Function cannot work with values of type String - But I use CONVERT and it still doesn't work... in DAX Commands and Tips

SUM Function cannot work with values of type String - But I use CONVERT and it still doesn't work...

A_Scott — Fri, 07 Apr 2023 15:03:05 GMT

I wrote a DAX statement:

Summary - Exit Surveys =

"Location currently has " & CONVERT ( [Str. Mgmt. Count], STRING ) & " members of store management and have completed "

& [Completed Exit Surveys] & " Unobstructed & Emergency Exit Verification surveys in the last 7 days."

I get the error:

The only measure in my DAX statement that is a SUM function in it's original measure is the [Str. Mgmt. Count], which I have incorporated the CONVERT function to solve for the value being a string. But it still won't work... the measure [Completed Exit Surveys] is a COUNT function in it's original measure.

I wrote a similar DAX statement that worked perfectly...

Summary - Meat Saw =

"This location currently has " & 'All Measures'[Meat Saw Count] & " meat saw(s) that " & [Meat Saw Are/Aren't Meeting Min.] & " meeting the minimum required inspections per day."

Re: SUM Function cannot work with values of type String - But I use CONVERT and it still doesn't work...

FreemanZ — Fri, 07 Apr 2023 15:19:58 GMT

hi A_Scott

Are you creating a column or a measure?
[Completed Exit Surveys] and [Str. Mgmt. Count], what are they?

Re: SUM Function cannot work with values of type String - But I use CONVERT and it still doesn't work...

A_Scott — Fri, 07 Apr 2023 19:37:16 GMT

I am creating a measure.

[Completed Exit Surveys] is : Completed Exit Surveys = DISTINCTCOUNT('Exit Survey Data'[ID]) +0

[Str. Mgmt. Count is] : Str. Mgmt. Count = sum('All Open Retail Locations'[Store.Mgr and ASL Count])

Even if I use the CONVERT function in the DAX for [Str. Mgmt. Count] instead of in the DAX for [Summary - Exit Survey] it still doesn't work.

Re: SUM Function cannot work with values of type String - But I use CONVERT and it still doesn't work...

tamerj1 — Fri, 07 Apr 2023 21:39:43 GMT

Hi A_Scott

please try

Str. Mgmt. Count =

SUMX (

'All Open Retail Locations',

VALUE ( 'All Open Retail Locations'[Store.Mgr and ASL Count] )

)

Re: SUM Function cannot work with values of type String - But I use CONVERT and it still doesn't work...

A_Scott — Mon, 10 Apr 2023 12:29:04 GMT

Worked perfectly! Thanks for your help