SPC (xmr chart) Control limits Help
I am calculating control limits using 2.66 * mean of the mean range. I can calculate the mean range (AbsoluteRange measure in my example). I then want to sum the mean range and divide by the number - 1 ( in my example this is sum of measure AbsoluteRangeCount) My issue is that I cannot sum the measures AbsoluteRange & AbsoluteRangeCount . I want to create a control limit for each cc in my data. -- this Code is working as expected AbsoluteRange = var currentvalue = max ( data1[column1] ) var currentcc = max ( data1[cc] ) VAR Earliervalue = CALCULATE ( max ( data1[column1] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] < SELECTEDVALUE ( data1[column1] ) ) ) var earliercc = CALCULATE ( max ( data1[cc] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] < SELECTEDVALUE ( data1[column1] ) && data1[cc] = currentcc ) ) return abs( if( not(isblank( CALCULATE ( max ( data1[value] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] = earliervalue && data1[cc] = earliercc ) ) )), CALCULATE ( max ( data1[value] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] = currentvalue && data1[cc] = currentcc ) ) - CALCULATE ( max ( data1[value] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] = earliervalue && data1[cc] = earliercc ) ) ) ) --This code is working as expected AbsoluteRangeCount = var currentvalue = max ( data1[column1] ) var currentcc = max ( data1[cc] ) VAR Earliervalue = CALCULATE ( max ( data1[column1] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] < SELECTEDVALUE ( data1[column1] ) ) ) var earliercc = CALCULATE ( max ( data1[cc] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] < SELECTEDVALUE ( data1[column1] ) && data1[cc] = currentcc ) ) return abs( if( not(isblank( CALCULATE ( max ( data1[value] ) ,ALLEXCEPT('data1','data1'[cc]) ,FILTER ( ALL( data1), data1[column1] = earliervalue && data1[cc] = earliercc ) ) )),1 ) ) -- this code is not working it gives nothing avgrangetest1 = CALCULATE(sumX(values(data1[cc]),([AbsoluteRange])) ) / CALCULATE(sumX(values(data1[cc]),([AbsoluteRangeCount])) )
