SPC (xmr chart) Control limits Help

SWAST — Tue, 22 Oct 2019 11:57:51 GMT

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])) )

topic SPC (xmr chart) Control limits Help in DAX Commands and Tips

SPC (xmr chart) Control limits Help