showing the value double i click SUM function instead of don't summarize

[Anonymous]

 i have the table  . values showing like year wise 2021 data value 32 only . 

please find the below screen shot refernce . 

when i change it to  Sum  .its values showing .

i am using below measure for the calculate the value.

warehouse infeasibility (tons) = DIVIDE(PM_Out_StockMovement[WarehouseInfeasibility],1000)

any idea. thanks in advance 

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, warehouse infeasibility (tons) is a measure, but how can it have three values ​​when it is alone in a visual, additionally, is [WarehouseInfeasibility] a measure or column? Could you please provide more sample data, it will help find the problem.

If you want to show correct total in summarize, you can calculate the sum based on old measure, like this:

SUMX(table,[ warehouse infeasibility (tons) ])

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ValtteriN]

Hi,
This problem is likely causes by the logic behind calculated column. To solve the issue check if your slicers are working. Additionally I would recommend using use a SUM measure instead of summarizing a calculated column.
So something like (

Divide Sum = DIVIDE(Sum('Summarize'[Value]),1000))

My test data:

Problem reconstructed:

Without any selections the divide seemingly works:

When changed to summarize the value doubles:

(Slicer) While I select 2021 from a slicer the value works as intended:

Hopefully this helps to solve the issue and if it does consider accepting this as a solution!