Forum Discussion
turcelaygoy
Helper I
3 years agoPossible loop in DAX
Hello! I was trying to calculate the variation of some faults in the different units of products and I have been able to see the variation between to independent units of products. I was wonderin...
- 3 years ago
Hi turcelaygoy
I think now is correct.Filtered variation_2 = AVERAGEX ( CROSSJOIN ( CROSSJOIN ( VALUES ( 'UT_INII'[UT1] ), VALUES ( 'UT_FIN'[UT2] ) ), VALUES ( 'Tabla Proyecto'[PROYECTO] ) ), VAR T = CALCULATETABLE ( Hoja1 ) RETURN AVERAGEX ( GENERATESERIES ( [UT1], [UT2] - 1, 1 ), VAR CurrentFaults = SUMX ( FILTER ( T, Hoja1[Columna] = [Value] ), Hoja1[FALTAS TOTALES (QA)] ) VAR NextFaults = SUMX ( FILTER ( T, Hoja1[Columna] = [Value] + 1 ), Hoja1[FALTAS TOTALES (QA)] ) RETURN DIVIDE ( NextFaults - CurrentFaults, CurrentFaults ) * 100 ) )
turcelaygoy
Helper I
3 years agoI have chosen project Oslo and initial UT 30 and final UT 32 and it returns me the variation between UT 30 and 33 that is 655% but it should say -67% (these results have been calculated filtering the variables in the excel sheet of the database). But then I have tried different projects and the variation that it returns is not correct. So right now the measure gives a result but not correct.
tamerj1
Community Champion
3 years agoCan you share a sample file?
- turcelaygoy3 years ago
Helper I
of the excel sheet or the power BI
- tamerj13 years ago
Community Champion
Power Bi
- turcelaygoy3 years ago
Helper I
It doesn't let me share the file