Forum Discussion

A_Scott's avatar
A_Scott
Icon for Helper I rankHelper I
3 years ago
Solved

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

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 Su...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi A_Scott 

    please try

    Str. Mgmt. Count =

    SUMX ( 

    'All Open Retail Locations',

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

    )

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi A_Scott 

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

A_Scott's avatar
A_Scott
Icon for Helper I rankHelper I
3 years ago

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.