Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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:

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?
Need Help
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , the formula and number seems correct.

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes, for sure. 

       

      Send you desired output

       

       

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        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