Subtract multiple values from same column using different filter and rows
Dear all, I'm pretty new to Power BI and I'm struggling to create a measure for a single table with 5 fields. The values for multiple substraction are all in the same column, but I want to use different filter for all the substracted values. I have four columns with (Date, Branch, CatType and Category) and a value field (MyValue). I want to build substraction for all Category = WOColor with same filter for Date, Branch, CatType and subtract values with same filter by Date, Branch, CatType but different Category as follows: Measure = MyValue (Category = WOColor) - MyValue(Category = Blue) - MyValue(Category = Red) - MyValue(Category = Green) applying for all MyValues the same filter for Date, Branch, CatType. Sample data: Is there a way to create a measure for it in Power BI? Thanks for all your efforts in advance.
