Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
30 | |
22 |