Forum Discussion

ConorMcCoy's avatar
ConorMcCoy
Frequent Visitor
4 years ago
Solved

Static Percentage Shrinkage

Hi All,    I need to get a rolling 28 day % figure for shrinkage - i.e. shrinkage/attended.    I need this figure to be static such that it does not change based on the date that is being display...
  • ConorMcCoy's avatar
    ConorMcCoy
    4 years ago

    I've actually figured it out. I needed to use the ALL function so the measure would ignore the filter context in the visual. The formula I've used is;

    (CALCULATE([In Office Shrinkage],all('Agent Data'),DATESINPERIOD('Agent Data'[Date],today()-1,-27,DAY)))/(CALCULATE([Actual Attended],all('Agent Data'),DATESINPERIOD('Agent Data'[Date],today()-1,-27,DAY)))

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago
I need to get a rolling 28 day % figure for shrinkage - i.e. shrinkage/attended. 

I need this figure to be static such that it does not change based on the date that is being displayed in the table.

 

My understanding is that these two requirements are mutually exclusive.  Please clarify.

ConorMcCoy's avatar
ConorMcCoy
Frequent Visitor
4 years ago

I've actually figured it out. I needed to use the ALL function so the measure would ignore the filter context in the visual. The formula I've used is;

(CALCULATE([In Office Shrinkage],all('Agent Data'),DATESINPERIOD('Agent Data'[Date],today()-1,-27,DAY)))/(CALCULATE([Actual Attended],all('Agent Data'),DATESINPERIOD('Agent Data'[Date],today()-1,-27,DAY)))