Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Help with calculation in Power BI Count

Hello everyone.

I have a model of 3 related tables:

  • 1 table of facts (Molders) columns of Date, Workshop, Molder (Name person), Parts delivered, Damaged parts.
  • 1 time table
  • 1 table of workshops
Every day each molder is given batches of pieces of wood that has to mold (each batch several in quantities) can also be delivered daily of 2 or more lots, in each batch for X reason some damaged parts may come out.
In the BI report I have a calculated measurement (% damaged parts) which is the division of damaged parts/between delivered parts.

I have a bar chart by name of the Molder where I can see what the % of each of them are, I can apply filters to see them by day, week, month or year, as well as by workshop.
Statement of the need:
I have 3 ranks as follows:
  • From 0% to 0.80% is sewn good (green color)
  • 0.81% to 1.20% is considered moderately good (yellow color)
  • of 1.21 or more is considered bad (Red color)
I want to show on labels the number of Bar Chart Molders that fall into each of these ranges.
As an example the graph below if the applied filters show this data on the labels see for reds 1, yellows 2 greens 3.
Graph only example the number of names are quite a few.

Thanks in advance.