ABC analysis with Slicer filter

[ali02]

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.

[Greg_Deckler]

What you want is to go to the Modeling tab and click on New Parameter.

[ali02]

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.

[Anonymous · Accepted solution]

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