Wrong in simple addition

What do your two measures look like?

One is a simple

CC_Int CSIP = DIVIDE(SUM('fact Controller Monthly Report'[Number of interactions]);2)

The other one is a selection of three possibilities depending on what data that is available

CC_Int = if(DIVIDE(SUM('fact Controller Monthly Report'[Number of interactions]);2)>0;DIVIDE(SUM('fact Controller Monthly Report'[Number of interactions]);2);IF([CC_Int Man]>0;[CC_Int Man];[CC_Int Calc Un-w]))

NOG

NOG,

Please create a new measure using DAX below , drag the measure to the visual and check the total value.

Measure = IF(COUNTROWS(VALUES('fact Controller Monthly Report'[CY/Mth]))=1, [CC_Int],SUMX(VALUES('fact Controller Monthly Report'[CY/Mth]),[CC_Int]))

Regards,
Lydia

Thank you

Tried some but couldn't make it work

Will try later when I have more time

I have done a workaround for now.

NOG

NOG，

Please share sample data of your table so that we can test.

Regards,
Lydia

Sorry for no reply but I think I know what it could be

Attached is a similar issue about Totals 

Look at the two columns to the right and their totals

It is not the column total it is clculated from left to right in the Total row

I want the column sum and not a calculation left to right???

//NOG

NOG,

Please share sample data of your original table in a Excel file where we can copy and paste. Also post expected result based on sample data here.

Regards,
Lydia