Total is not calculating due to some null

[deeavhad]

My Expression is below

((sum({<UKI_ES_State={'Cancelled', 'Closed Complete', 'Resolved'}>} if(UKI_ES_State='Cancelled',5,if(Match([UKI_ES_Items],'0'),1,[UKI_ES_Items])))+NullCount({<UKI_ES_State={'Cancelled', 'Closed Complete', 'Resolved'}>}if(UKI_ES_State='Cancelled',5,if(Match([UKI_ES_Items],'0'),1,[UKI_ES_Items]))))*Sum([SN AHT]))/20
+ if((if([Audit Group]='Comp - Group B',QA_AHT,QA_AHT*Volumes)/20)=Null(),0,if([Audit Group]='Comp - Group B',QA_AHT,QA_AHT*Volumes)/20)

+(sum(AHT_AA)+sum({<[Activity Type]={'Production'}>}Minutes))/20

these are 3 measure which I am trying to add by plus(+) sign but its not calculating where one of the measure is null

in this screenshot I am trying to add column "Processing EQ", "QA EQ" and "Adhoc+Aloocation+Production"

Please help me to get this total if one of the column is blank

[tresesco · Accepted solution]

Try using RangeSum() instead, like: Rangesum(col1, col2, col3)

[deeavhad]

I tried it but not worked

[Digvijay_Singh]

May be use Coalesce() for the measure which might give null value.

I normally use Column(1) + Column(2) + .... but some don't prefer that because change of position of measures might break it sometimes..