Forum Discussion
pawelj795
Post Prodigy
Post ProdigySum 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.
pawelj795Post Prodigy
Post Prodigyv-kelly-msft
Nope, it's not what I'm looking for.
Look on screenshot with my real data.
In my report, I need to exclude Items with no TransType 0 or 9.
I don't want to only exlude transactions, but whole Item.
In above example, Item with number 1-2-0105-0052 should be exclude entirely from my matrix.
pawelj795Post Prodigy
Post Prodigyup