Forum Discussion

turcelaygoy's avatar
turcelaygoy
Helper I
3 years ago

Calculate permutation

Hello!  I'm trying to calculate an evolution of faults calculating the average of the variations between two not consecutive cars. But I want to do a permutation and calculate the variation of each ...
turcelaygoy's avatar
turcelaygoy
Helper I
3 years ago
Quality variation_COCHE2 = 
AVERAGEX ( 
    CROSSJOIN ( 
        VALUES ( 'Tabla Proyecto'[PROYECTO] ),VALUES('Tabla Area'[AREA]) ), 
    VAR T = 
        CALCULATETABLE ( Hoja1 ) 
    RETURN 
        AVERAGEX ( 
           GENERATESERIES ( MIN(Hoja1[ORDEN COCHE PROYECTO]), MAX(Hoja1[ORDEN COCHE PROYECTO]) -1 , 1 ), 
           var Z= [Value] 
               AVERAGEX( 
                  GENERATESERIES ( Z , MAX(Hoja1[ORDEN COCHE PROYECTO]) - 1 , 1 ),
                    VAR W = [Value] 
                    VAR CurrentFaults = SUMX ( FILTER ( T, Hoja1[ORDEN COCHE PROYECTO]= Z), Hoja1[FALTAS TOTALES (QA)] )
                    VAR NextFaults = SUMX ( FILTER ( T, Hoja1[ORDEN COCHE PROYECTO]= W + 1 ), Hoja1[FALTAS TOTALES (QA)] ) 
    RETURN 
         DIVIDE ( NextFaults - CurrentFaults, CurrentFaults ) * 100 )
 ) 
)

I came up with this but I would like to know if there is any option of making the variables Z and W work. Right now the measure doesn't work due to those two variables.