Help with calculation in Power BI Count

[Syndicate_Admin]

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.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Syndicate_Admin]

Here is the link where the example file is

https://drive.google.com/file/d/1gdhDGIew65bkzjZt3QLx_mB2jgVoEK6w/view?usp=drivesdk

Best regards.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Syndicate_Admin]

Best regards.

The measure works well at the week level, applying other filters does not change the values.

[Ashish_Mathur]

Hi,

The result is correct.  I selected Lomas and i get the correct result in the Table at the bottom left.

[Syndicate_Admin]

Oops, apologies are right, I had a bad rule of conditional formatting and I was guided only by the color of the bars.

Thank you very much, today yes.

Best regards.

[Ashish_Mathur]

Hi,

If my previous reply helped, please mark that as Answer.