Forum Discussion
Running total by category
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!!!
Silex_BI Add to your calculate another statement:
CALCULATE(
...
...,
REMOVEFILTERS('Table'[Transaction Type])
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBISilex_BI if you want you can PM me now and we could do a quick zoom
Silex_BI check that you put the right column from the right table.
4 Replies
- SpartaBI
Community Champion
Silex_BI Add to your calculate another statement:
CALCULATE(
...
...,
REMOVEFILTERS('Table'[Transaction Type])
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI