Wrong in simple addition

[NOG]

The column CC_Int CSIP and CC_Int deliver the same Total?

How?

The last two number in CC_Int is not in CC_Int CSIP and anyway the total is the same????????

NOG

[LukeWalker]

What do your two measures look like?

[NOG]

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

[v-yuezhe-msft]

@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

[NOG]

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

[v-yuezhe-msft]

@NOG，

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

Regards,
Lydia

[NOG]

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

[v-yuezhe-msft]

@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