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:
If you like this reply, please give kudos. And if this solves your problem,
please accept this reply as the solution.
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"
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
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT