Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
Hi @willythecat for test 2 measure solution there will be 5 measures as following (only color for 3 is different)
Kudos appreciated / accept solution.
Proud to be a Super User!
Hi @willythecat one possible solution is measure as below. Adapt your table names and columns or Category values name as needed. I got amounts as yours
Kudos appreciated / accept solution.
Proud to be a Super User!
Hi @some_bih ,
thank you for your reply.
I probably explained the task incorrectly. In the sample above the result should be calculated in column F (with header Measure), where Measure = MyValue (Category = WOColor) - MyValue(Category = Blue) - MyValue(Category = Red) - MyValue(Category = Green) => 171.330.883,45 - 14.807.357,66 - 15.808.107,3 - 172.222.032,19 = -31.506.613,70
The calculation should be done for all Category = WOColor.
Thank you
Hi @willythecat for test 2 measure solution there will be 5 measures as following (only color for 3 is different)
Kudos appreciated / accept solution.
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
12 | |
11 | |
10 | |
9 |