Grand total is not working properly

[ShaikRafi]

Hi Team,

I create new measure to get values ,logic working fine but grand total showing wrong

IF(HASONEVALUE('Marketing FTD'[Reporting Channel]),
SWITCH(VALUES('Marketing FTD'[Reporting Channel]),"Direct",

SUMX(VALUES('Marketing FTD'[Reporting Channel]),COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Reporting Channel]),[Marketing No of FTD]))),
COUNT('Marketing'[FTD_Count])),COUNT('Marketing'[FTD_Count]
)
)

[amitchandak]

@ShaikRafi , Try like

SUMX(VALUES('Marketing FTD'[Reporting Channel]),
IF(HASONEVALUE('Marketing FTD'[Reporting Channel]),
SWITCH(VALUES('Marketing FTD'[Reporting Channel]),"Direct",

SUMX(VALUES('Marketing FTD'[Reporting Channel]),COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Reporting Channel]),[Marketing No of FTD]))),
COUNT('Marketing'[FTD_Count])),COUNT('Marketing'[FTD_Count]
)
))

Sumx is need on overall