Forum Discussion
pawelj795
Post Prodigy
6 years agoSum rows only with specific values in other column
Hi, I have database with inventory values like below. (sample data) Now, I want to create measure, which gonna calculate YTD value, but only for Items, which never had Transtype 0 or 9.
pawelj795
Post Prodigy
6 years agov-kelly-msft
Even with my above adjustments or with precisely your measure, it still only exlude transactions with trans type 0 or 9, not whole Index (ItemID)
pawelj795
Post Prodigy
6 years agov-kelly-msft
It's possible to do what I want?