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

[A_Scott]

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."

[tamerj1 · Accepted solution]

Hi @A_Scott 

please try

Str. Mgmt. Count =

SUMX ( 

'All Open Retail Locations',

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

)

[A_Scott]

Worked perfectly! Thanks for your help

[FreemanZ]

hi @A_Scott 

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

[A_Scott]

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.