Forum Discussion
Solved
Production Order Count by Duration
Hello. I need to count the number of production orders by duration time (in hours). The graphic needs to be similar as below. How can I do it in Power BI? Example data is below the example graphi...
Hi GustavoKamchen ,
Please try:
First create a new table:
Then create a measure:
Measure = CALCULATE(COUNT('Table'[Duration (Hours)]),FILTER('Table',[Duration (Hours)]>=MAX('Table 2'[Value])&&[Duration (Hours)]<MAX('Table 2'[Value])+1))Apply it to the visual:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi GustavoKamchen ,
Please try:
First create a new table:
Then create a measure:
Measure = CALCULATE(COUNT('Table'[Duration (Hours)]),FILTER('Table',[Duration (Hours)]>=MAX('Table 2'[Value])&&[Duration (Hours)]<MAX('Table 2'[Value])+1))Apply it to the visual:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.