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
What you want is to go to the Modeling tab and click on New Parameter.
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
