cancel
Showing results for
Did you mean:
Highlighted
Helper III

Promedio de la matriz incorrecto

Hola,

En la matriz que estoy creando lel promedio de la columna de total me sala incorrecto, ¿Cómo puedo corregirlo?

Este calculo lo obtengo de la siguiente manera:

1. CALCULATE(COUNTROWS(TableLine),TableLine[TESTRESULT]="1")

3. ICC = DIVIDE([Count 1], [Count Total], 0)

ICC son los valores que aparcen en la tabla.

¿Alguna idea?
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

Hi @vsgarciap ,

Would you please refer to the following meause for ICC:

``ICC = IF(HASONEVALUE(GIMInventQualityOrderLineResultStaging[TEST]),DIVIDE([Count 1], [Count Total], 0),AVERAGEX(SUMMARIZE(GIMInventQualityOrderLineResultStaging,GIMInventQualityOrderLineResultStaging[TEST],"A",DIVIDE([Count 1], [Count Total], 0)),[A]))``

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

5 REPLIES 5
Highlighted
Super User IV

@vsgarciap , the formula and number seems correct.

Can you share sample data and sample output in a table format?

Proud to be a Super User!

Highlighted
Helper III

Yes, for sure.

Send you desired output

Highlighted
Microsoft

Hi @vsgarciap ,

Would you please explain what is the logic of your Total general?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Highlighted
Helper III

Es la suma de las cantidades que aparecen a lo largo de la fila dividido entre las cantidades que hay, es decir, un promedio.

Highlighted
Microsoft

Hi @vsgarciap ,

Would you please refer to the following meause for ICC:

``ICC = IF(HASONEVALUE(GIMInventQualityOrderLineResultStaging[TEST]),DIVIDE([Count 1], [Count Total], 0),AVERAGEX(SUMMARIZE(GIMInventQualityOrderLineResultStaging,GIMInventQualityOrderLineResultStaging[TEST],"A",DIVIDE([Count 1], [Count Total], 0)),[A]))``

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Announcements

Power Platform Community Conference

Check out the on demand sessions that are available now!

Microsoft Power Platform Communities

Check out the Winners!

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors