Summation not providing correct result set in BI.

[Swathi1]

Hi, I have two rows values in the table level like 60& 60. If I will do sum in the front end report level I am getting 240. Any option I need to change.

[Anonymous]

Hi @Swathi1 ,

Has your problem been solved? If not, please share the sample file so we can help you better.

Best regards,
Community Support Team_ Scott Chang

[vojtechsima]

Hello,

@Swathi1 that is very strange.

Do you use your own measure, like SUM('Table'[Column])?

Alternatively, this can't happen if this is your only table, perhaps you have some Many To Many relationship that's create duplication.

Check Model, Power BI (unless you say differently) creates relationships automatically, perhaps there are some unwanted ones.

Alternatively share a link with your .pbix and I can have a direct look.

[Swathi1]

 Hi,

I am using following calculation ,

Create a cloumn  = if (Table name [specific column]="X" && Table name [specific column]="Y", (Table name [specific column])) and on top it selecting sum option in the summariazation level. 

[vojtechsima]

Hello, @Swathi1 ,

try rewriting it as a measure:

CALCULATE(
SUM('table'[ColumnForSum]),
'table'[specific column]="X" && 'table'[specific column]="Y"
)

I suggest in general avoiding implicit measures (clicking Sum button on top) and writing your own measures.