Measure to calculate total in Bar Cluster chart

[chavanr]

Hi there,

I am trying to calculate total for a Cluster Bar chart, but it is giving me the following error

I have created a Table :

ChartAxis = UNION(VALUES('WDC StreetWise'[Service]), ROW( "Service", "All"))

And the measure for the same:

HHByService =

VAR A = MAX(ChartAxis[Service])

RETURN

IF(A<> "ALL",

CALCULATE(

SUM('WDC StreetWise'[Custom]),'WDC StreetWise'[Service] =A),

CALCULATE(SUM('WDC StreetWise'[Custom]),ALLSELECTED('WDC StreetWise')

)

)

[ryan_mayu · Accepted solution]

@chavanr 

the error looks like you are using the sum function on a text column. maybe try to change the data type to number?

if not, pls provide the sample data and expected output