Rolling 12 months

[boehnc]

I have a calculated column below to calculate a rolling 12 months. I have 6 slicers including an 'All Proc'[Year] and 'All Proc'[Month] slicer. How do I write the code below to disregard all of the slicers? I've tried (All, 'All Proc') at the end of the calculation, but that doesn't seem to do the trick. Thank you.



Rolling 12 Month Rate:=calculate([Count of TYPE]/[Count of Surg]*100,filter('All Proc' ,'All Proc'[ProcedureDate]>=[RollingYearBegin]&&'All Proc'[ProcedureDate]<=[RollingYearEnd]))

 

[Matt Allington]

are you sure you have this as a calc column? It looks like a measure to me.

To answer your question, you need to wrap the name of the slicer column (or table name) inside an ALL() statement. So replace the formula stub FILTER('All Proc', with FILTER(ALL('All proc'),

if if you are using a calc column, you should switch