topic Re: Running total by category in DAX Commands and Tips

Running total by category

Silex_BI — Sat, 23 Jul 2022 14:06:44 GMT

Hi,

This is probably an easy one but I'm stumped.

I have a inventory transaction table that record inventory movements.

I have created a measure that calculate the inventory position by date (running total) which works fine:

However, as soon as I try to add detail in my table (such as transaction type), the logic breaks:

Does anyone have a clue how to fix this?

Thanks a lot!!!

SpartaBI — Sat, 23 Jul 2022 15:16:34 GMT

Silex_BI Add to your calculate another statement:
CALCULATE(
...
...,
REMOVEFILTERS('Table'[Transaction Type])
)

Silex_BI — Sat, 23 Jul 2022 15:24:24 GMT

Hi SpartaBI,
Thank you for your answer, unfortunately it doesn't seem to solve it:

Any idea why?

SpartaBI — Sat, 23 Jul 2022 15:26:09 GMT

Silex_BI if you want you can PM me now and we could do a quick zoom

SpartaBI — Sat, 23 Jul 2022 15:41:59 GMT

Silex_BI check that you put the right column from the right table.