Slicer is Not Working

[MYKJ]

Hi all, I am getting a problem regarding a slicer. i made a measure Sensitivity which includes two measures like sell thru and net days. sensitivity measure are not appearing in Slicer. please help me out 

sensitivity =  If([Sell Thru] > 0 && [Sell Thru]<= 0.19 && [Net Days] > 15 && [Net Days] <= 30, "Critical",

If([Sell Thru] > 0.19 && [Sell Thru]<= 0.25 && [Net Days] > 15 && [Net Days] <= 30, "Average",

If([Sell Thru] > 0.30 && [Sell Thru]<= 0.35 && [Net Days] > 15 && [Net Days] <= 30, "Good",

If([Sell Thru] > 0.35 && [Sell Thru]<= 1 && [Net Days] > 15 && [Net Days] <= 30, "Excellent",

If([Sell Thru] > 0 && [Sell Thru]<= 0.35 && [Net Days] > 30 && [Net Days] <= 45, "Critical",

If([Sell Thru] > 0.35 && [Sell Thru]<= 0.45 && [Net Days] > 30 && [Net Days] <= 45, "Average",

If([Sell Thru] > 0.45 && [Sell Thru]<= 0.55 && [Net Days] > 30 && [Net Days] <= 45, "Good",

If([Sell Thru] > 0.55 && [Sell Thru]<= 1 && [Net Days] > 30 && [Net Days] <= 45, "Excellent",

If([Sell Thru] > 0 && [Sell Thru]<= 0.50 && [Net Days] > 45 && [Net Days] <= 60, "Critical",

If([Sell Thru] > 0.50 && [Sell Thru]<= 0.60 && [Net Days] > 45 && [Net Days] <= 60, "Average",

If([Sell Thru] > 0.60 && [Sell Thru]<= 0.70 && [Net Days] > 45 && [Net Days] <= 60, "Good",

If([Sell Thru] > 0.70 && [Sell Thru]<= 1 && [Net Days] > 45 && [Net Days] <= 60, "Excellent",

If([Sell Thru] > 0 && [Sell Thru]<= 0.64 && [Net Days] > 60, "Critical",

If([Sell Thru] > 0.64 && [Sell Thru]<= 0.75 && [Net Days] > 60, "Average",

If([Sell Thru] > 0.75 && [Sell Thru]<= 0.84 && [Net Days] > 60, "Good",

If([Sell Thru] > 0.75 && [Sell Thru]<= 1 && [Net Days] > 60, "Excellent"))))))))))))))))

[Anonymous · Accepted solution]

Hi  @MYKJ ,

Measure cannot be used in Slicer, you can consider creating a table to store the value of measure.

Here are the steps you can follow：

1. Use Enter data to create a table.

2. Create measure.

Flag =
var _selet=SELECTEDVALUE('Slice Table'[Slice])
return
IF(
    _selet=[sensitivity],1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

The column [Slicer] of the new table is used as a slicer, and when selected, the data corresponding to the sensitivity is displayed.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Whitewater100]

Hi:

I think you would be better having set up a Sensitivity-Statusconfiguration table which you can run logic thru. I'd do that in excel and import it in.  Here's a rough version of a start of one: My answer is not conceptually differet than the first reply, just a few more details.

SENSITIVITY TABLE

Status	Low ST	High ST	Low Days	High Days
Critical	0	0.19	0	15
Bad	0	0.19	15	30
Fair	0	0.19	30	50
Better	0	0.19	50	70
Best	0	0.19	70	90
Critical	0.19	0.25	0	15
Bad	0.19	0.25	15	30
Fair	0.19	0.25	30	50
Better	0.19	0.25	50	70
Best	0.19	0.25	70	90

Assuming these data points (Sell-thru & Days are in another Table you would make a new Calculated column in that table. You would use the values on this new calculated column for your slicer.  The Calculated Column/ Slicer could be a formula like this:

Sensitivity =  CALCULATE(VALUES((SensitivityTable[Status]), 
FILTER(Sensitivity,

Table[Sell-thru] >= Sensitivity[Low ST] && Table[Sell-thru] < Sensitivity[High] && 
Table[Days] >= Sensitivity[Low Days] && Table[Days] < Sensitivity[High Days])
)

This would put a Status on each row of the table where Sell-Thru & Net Days live. 

Just need to make sure you have everything covered in the sensitivty table. (I didn't see a Sell Thru at .26 and Net Days between 15 -30 ..as an example.

This could e not great performance wise if you have a lot of data due to how many breakouts you have. 

Hope this helps!

I hope this helps.

[Tanushree_Kapse]

Hi @MYKJ ,

Make this a Column and not a measure. And then use this column in your slicer field. this would work.

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

[MYKJ]

Its only showing single row when i make this measure into column.