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 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'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] )

    )

4 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    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.