Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
A_Scott
Frequent Visitor

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:
A_Scott_0-1680879461658.png

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."
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @A_Scott 

please try

Str. Mgmt. Count =

SUMX 

'All Open Retail Locations',

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

)

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

Hi @A_Scott 

please try

Str. Mgmt. Count =

SUMX 

'All Open Retail Locations',

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

)

Worked perfectly! Thanks for your help

FreemanZ
Super User
Super User

hi @A_Scott 

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

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors