Duplicated Values in PieChart

[Anonymous]

I want t show the values with the highest downtime , but the pie chart is showing duplicated values
hoy can i group them or show no duplicated

[eka24]

You can add Distinct or Group By to your Collection. Can you show your formula for the community to help

[Anonymous]

Filter('[dbo].[Stopwords]',Linea="D2",'Tiempo de Reparacion'>=10)

I'm using my SQL Table where all the information is send

[eka24]

Please try this:

Distinct(Filter('[dbo].[Stopwords]',Linea="D2",'Tiempo de Reparacion'>=10),Linea)

[Anonymous]

Didn't work
The Chart will not display anything 

[eka24]

Since there are duplicates which may also have corresponding duplicated figures on the column 'Tiempo de Reparacion', i suggest we group the Linea column. That is only one name per Linea, then all figures are also put together for 'Tiempo de Reparacion'. this is the formula:

1. AddColumns(

GroupBy('[dbo].[Stopwords]',"Linea","SumTiempo"),

"Totals", Sum(SumTiempo,'Tiempo de Reparacion'))

2. If you want to filter Linea then:

Filter(AddColumns(

GroupBy('[dbo].[Stopwords]',"Linea","SumTiempo"),

"Totals", Sum(SumTiempo,'Tiempo de Reparacion')),Linea="D2")

If you want to filter 'Tiempo de Reparacion' (Total) then:

Filter(AddColumns(

GroupBy('[dbo].[Stopwords]',"Linea","SumTiempo"),

"Totals", Sum(SumTiempo,'Tiempo de Reparacion')),Linea="D2",Totals>=10)

If you like this reply, please give kudos. And if this solves your problem,
please accept this reply as the solution.

[Anonymous]

Let me explain it better

I have a Table call "stopwords" in that table i have several columns

Like "Line" , "Tiempo_de_reparacion" , "Tipo de Falla"

what i want is that the PieChart shows the "Tipos de Falla" filtered by "Tiempo de reparacion >= 10" and Line
I use this formula and it works fine BUT I don't want to see duplicates


Filter('[dbo].[Stopwords]',Linea="D2",'Tiempo de Reparacion' >= 10)
In the Labels i have "Tipo de Falla" and Series "Tiempo d Reparacion"

[eka24]

Do the items with duplicates also have corresponding figures in the column Tiempo_de_reparacion ?
If so, when you remove the duplicate, do you want the corresponding figures to be deleted or added?
You are now introducing Tipo de Falla" but I can't see it in your formula that is working

Waiting for feedback

[Anonymous]

That is the table 
As you can se I have the column "Tipo de Falla" and on the Left there is "Tiempo de Rep"
and I have more records and The value "Electrica" from Tipo de Falla appears several times
what i want is that all those value get grouped and displays only 1 record for each like

Tipo de Falla Electrica there is 4 records the sum of the Tiempo de Rep = 21 min
Tipo de Falla Set up there is 1 record the sum of the Tiempo de Rep = 6 min
Tipo de Falla Neumatica there is 1 record the sum of the Tiempo de Rep = 2 min
and so on

[Anonymous]

and here is the PieChart Formula, Labels and Series