How to SUM text fields

[meeradominic]

Hi,

I have table like below.

This is an example of a request's data. There will be diffrent types of requests. Each can have variable number of fields. 
The request is a separate table which has a relationship to the above fields table. From the example above, I need to create a measure showing the total number of claims and total receipt. 
Problem: Since my field value is a text coumn. I can't directly take the Sum of that column. I tried below. That did not work. Please help.

Total Claims = CALCULATE(SUM(VALUE('Request Parameters'[Field Value])),'Request Type'[Request Name]="My Request Type",'Request Parameters'[DisplayName]="Number of claims")

**Request Parameters - is shown in image
** Request Type is a dimension table having all the requests types

[meeradominic]

@amitchandak I duplicated the field_value column and changed the type of the column to decimal. And replaced all the errors with null. This resolved my issue. Thanks!!

[meeradominic]

@Amit could you throw some light on how I can split number & text in power Query?

[amitchandak · Accepted solution]

@meeradominic , In power query separate out text and non text rows and then create a measure