Forum Discussion
ABC analysis with Slicer filter
Hi ali02,
You can add new table as the source of slicer, then use result as the variables of original formula.
Sample:
Source table:
Table = GENERATESERIES(0,1,0.01)
Measure formulas:
Selected = var _min= MINX(ALLSELECTED('Table'),[Value]) var _max=MAXX(ALLSELECTED('Table'),[Value]) return _min&"/"&_max ABC Class = VAR _min = MINX ( ALLSELECTED ( 'Table' ), [Value] ) VAR _max = MAXX ( ALLSELECTED ( 'Table' ), [Value] ) RETURN SWITCH ( TRUE (), [Cumulated %] <= _min, "A", [Cumulated %] <= _max, "B", "C" )Regards,
Xiaoxin Sheng
Even if I do create a New Parameter, I still need to make sure that if I change my parameter values, my cumulative values changes as well as ABC Class.
These are my initial conditions.
These are what I want if I change my parameters or create a slicer and filtering it. But I am not able to create something that will give me these values. I have to go back to the formula everytime to change the conditions. I want to create filter so that the user can easily change the value.
Hi ali02,
You can add new table as the source of slicer, then use result as the variables of original formula.
Sample:
Source table:
Table = GENERATESERIES(0,1,0.01)
Measure formulas:
Selected =
var _min= MINX(ALLSELECTED('Table'),[Value])
var _max=MAXX(ALLSELECTED('Table'),[Value])
return
_min&"/"&_max
ABC Class =
VAR _min =
MINX ( ALLSELECTED ( 'Table' ), [Value] )
VAR _max =
MAXX ( ALLSELECTED ( 'Table' ), [Value] )
RETURN
SWITCH ( TRUE (), [Cumulated %] <= _min, "A", [Cumulated %] <= _max, "B", "C" )
Regards,
Xiaoxin Sheng