Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
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
@Anonymous , the formula and number seems correct.
Can you share sample data and sample output in a table format?
Yes, for sure.
Send you desired output
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
Es la suma de las cantidades que aparecen a lo largo de la fila dividido entre las cantidades que hay, es decir, un promedio.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |