Power BI incorrect lead times

[bektasb]

Hello

I calculated the running time and inserted it into a column chart

Unfortunately I have a problem

There are individual measuring devices in which the running time elapses and there are boxes (groups of measuringdevices) in which measuring devices are installed

Currently I get the lead time from the box and the lead time from the measuring equipment installed in the box.

So I have duplicate values in my chart.

How can I make it so that I only get the running time from the box, since I also automatically get the running time from the measuring devices that are installed in the box.

Instead of it being reported to me

Box 10 > 5 days

Part 1 > 5 days

Part 2 > 5 days

Part 3 > 5 days

Box 10 > 5 days

The boxes have an extra number as a supernumber

Box 10 has the number 111111

This means that in this box 10 is part 5

with the number 111 part 6 with number 222

part 7 with number 333

I hope it is

understandable

[Anand24]

Hi @bektasb ,
Can you provide data in table and expected output?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[bektasb]

 Hello, unfortunately I couldn't upload an Excel file. Here is a screenshot of the Excel table. I transform it into

Power Bi.

1. How can I display the throughput time of the box (thus the individual measuring equipment

throughput time is automatically displayed, the individual measuring equipment does not have to be displayed)

2. It must be clear how many measuring devices are in the box because I also have to show the number of measuring devices.

hope it's

understandable