Forum Discussion
ABC analysis with Slicer filter
Hi everyone,
So I have been wroking on ABC segmentation and did manage to create one. Now everytime if I need to filter my class, I have to go back again to the formula and change it. For e.g,
ABC Class = SWITCH (TRUE (),[Cumulated %]<= 0.8, "A",[Cumulated %] <= 0.95, "B","C")
Above is my DAX formula. So everytime I need to go back to the formula to change my Cumulated% value i.e. 0.8 to 0.75 for A.
I want to create a slicer filter where I can change the values right on the visuals and that would change my ABC class. I have not found anything on the internet regarding this. Any help would be highly appreciated.
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
3 Replies
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
