Need help with measure.

[Anonymous]

Hi All. I am trying to create a measure/calculated column using below formula:

Measure3 = var a = CALCULATE(SUMX(AM,AM[Column]),

FILTER (AM,AM[AM_OR_ATE]="Account Manager"))

return IF(ISBLANK(a),0,a)

And I am getting an error like this:

How do i correct it ? Any help would be much appreciated. Thanks in Advance! 

[Uspace87]

Have you checked the data type of  the field "am[Column]"? Maybe is formatted as text

[Anonymous]

yes it is of text data type and it is not changing to whole number

[amitchandak]

@Anonymous , This measure the data type AM[Column] is Text, change it whole number or use countx

you can also try

Measure3 = var a = CALCULATE(SUMX(AM,AM[Column]*1),
FILTER (AM,AM[AM_OR_ATE]="Account Manager"))
return IF(ISBLANK(a),0,a)

[Anonymous]

I am getting an error like this

[Uspace87]

It Seems in your source you have the value formatted as M. Try to sobstitute "S" and "M" with "" and then multply all the column by  1,000,000

[Uspace87]

@Anonymous 

Can you change it to Whole Number Or Decimal Number in power query Editor?

[Anonymous · Accepted solution]

I have a column called "Opp Value" and by doing sum value, the measure is working for now