Forum Discussion

A_Scott's avatar
A_Scott
Helper 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
    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] )

    )