Disconnected slicers, DAX measure

[shophoney]

Hi I have an Excel DAX measure for items that are selling well or poorly.

I would like to create a Slicer to selected "SLOW" or "FAST" moving items. But I dont know how to go about doing it.

I've read something about disconnected slicers. Can anyone help.

SELL THROUGH TREND:=IF('tblInvSkuMaster'[RECEIVED AGED]*.06<[SELL THROUGH],"FAST",IF('tblInvSkuMaster'[RECEIVED AGED]*.05>[SELL THROUGH],"SLOW"))

Thanks

 

[gazpage]

Can this calc be done on a row by row basis? If so then just add a calculated column and filter by that.

 

[shophoney]

I only wish. But it’s for the total units received for all size over units sold. Then I look at how the over all model is performing.

Rate of sale and sell through.

 

[gazpage]

Is Item a column in your table? If so, create a new table with a list of just the products and connect that to the colum in your main table. Then add the calculated column to that new table.