cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
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?

Adjunto imágen:

Captura.PNG

Este calculo lo obtengo de la siguiente manera:

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

2. Count Total = COUNTROWS(TableHeader)

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

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]))

 

Capture.PNG

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

 

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

@vsgarciap , the formula and number seems correct.

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

Yes, for sure. 

 

Send you desired output

 

icc.PNG

 

Highlighted

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

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

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]))

 

Capture.PNG

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

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors