Running total by category

[Silex_BI]

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 · Accepted solution]

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

      

Showcase Report – Contoso By SpartaBI

[SpartaBI · Accepted solution]

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

[SpartaBI · Accepted solution]

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

      

Showcase Report – Contoso By SpartaBI

[Silex_BI]

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

Any idea why?

[SpartaBI · Accepted solution]

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

[SpartaBI · Accepted solution]

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