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.
v-kelly-msft
Community Support
Community SupportHi pawelj795 ,
a=0 means there's no 0 in the column, so is b ,so a=0&&b=0 means there's no 0 or 9 in column ID, you said all the rows which contains 0 or 9 in column ID and TransType should all be excluded...so in my measure I have excluded all the posibilities.I have checked my result,it satisfies your need,where do you find not work?
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
pawelj795Post Prodigy
Post ProdigyHi v-kelly-msft,
I tried to do what I want in your file and it still doesn't work.
Look on shared pbix.
https://drive.google.com/open?id=1DpCDU2v4xJwMyeXjbFMCJX5RAFQEZg6N
ItemID's which I marked should be also on the table rightward.
Why they aren't?