Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I would like to ask you for help with following issue:
I have the table "PRODUCTION" with data about orders, operations and production hours:
As you can see I have 4 orders (1060370272, 1060370274, 1060371650, 1060371662) with different operations and different reported hours. What I want to achieve is the chart with SUM of hours but only for each order which contain operation "0200". In that case the result looks like this:
The question is how to define formula for calculation of that kind of measure.
Thank you for help!
P.
Solved! Go to Solution.
hi @Peter_2020 - You can implement the same using the below approach.
1. I have created a measure for Total Hours: Tot Hours = SUM(PRODUCTION[Hours])
2. Added a calculated column to identify Orders which have operation type "0200" :
Operation_check = IF ( PRODUCTION[Operation] = "0200" , 1, 0)
3. Plotted Orders vs. Tot Hours and then applied a visual level filter to only show orders that had a "Operation_check" = 1
Please mark the post as a solution and provide a 👍 if my solution helped with solving your issue. Thanks!
Proud to be a Super User!
hi @Peter_2020 - You can implement the same using the below approach.
1. I have created a measure for Total Hours: Tot Hours = SUM(PRODUCTION[Hours])
2. Added a calculated column to identify Orders which have operation type "0200" :
Operation_check = IF ( PRODUCTION[Operation] = "0200" , 1, 0)
3. Plotted Orders vs. Tot Hours and then applied a visual level filter to only show orders that had a "Operation_check" = 1
Please mark the post as a solution and provide a 👍 if my solution helped with solving your issue. Thanks!
Proud to be a Super User!
hi @Peter_2020 - Happy to help! 🙂
Do kudo the solution so it highlights to other folks with a similar request as well. Thanks!
Proud to be a Super User!
Maybe you can try
CALCULATE(SUM(Hours),FILTER(TABLE, OPERATION="0200")
Proud to be a Super User!
sorry Ryan, but it doesn´t work. I need to define somehow that I need calculate sum of all rows for column "hours" just for orders which contain operation "0200"...
please provide some sample data and the expected output.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |