Wrong total column

[Raul09]

Hi,

I'm having a problem were this measure gives wrong totals on a table visual 

= Cost SS Total = (([Over Stock]*'Unit Cost'[Unit Cost 2]))

Over Stock = ([Ideal]-[Total Available]) is a measure and Unit Cost 2 is a table column

The total is not calculating between rows wich gives the wrong results

Thanks in advance.

[Interkoubess]

Hi @Raul09,

I don"t know how your data are stored but did you try Sumx( your table, (([Over Stock]*'Unit Cost'[Unit Cost 2])).

Please give a sample with results and will try to help.

Thx.

[Raul09]

thanks for your reply @Interkoubess but that isn't working.

My data comes from sql database in form of views,. i have a table for my SKU LIST so i can create relationships between all data.

then i have this tables:
- Inventory

- Production

- Sales

- Cost

i need to calculate my over stock cost by doing this:
Total Stock = Available on Hand + In production

Overstock = Total Stock - Avg Sales per month

Overstock Cost = Overstock * Unit Price

my first column on my table is my SKU, so every row have individual calculations for all of that.

My row calculations are fine, but the totals is calculating between totals and not between rows

[v-yulgu-msft]

Hi @Raul09,

From current description, it's hard to image what expected result is and what wrong total values you have got. Please illustrate your scenario with sample data (table structure, column names, detailed rows). You could post some screenshots to show us current result you have got and tell us how to generate correct value with examples.

Regards,
Yuliana Gu