Help with - How to Slice by the results of a measure

[wheelerma55]

I would like to have the functionality of a column-based slicer using a measure column as my slicing feature.

What I would like my slicer by measure to produce.

What I get is a semi sort of the select item that disappears if reverse sorted.

Slicing method based on: DAX Fridays #204: Slice by the results of a measure

https://www.youtube.com/watch?v=xO9Caya9Qxw

PBIX attached link: https://drive.google.com/file/d/129-Wk-Dhfh2H6FqQgb8okyz4Vf8zn2SY/view?usp=sharing

All data anonymized.

[lbendlin]

You probably know that slicers only work with columns (native or calculated), not with measures. Maybe explain your goal a bit more.

[wheelerma55]

I understand that typically one slices with a column. In this case, I have constucted a measure which calculates a category. I would like to use this measure category to filter my table results. If the measure is placed within the filter panel and then a specific category entry is applied it filters as expected. I want this type of functionality usable in some type of selectable button which shows only the selected results. There are solutions referenced which can do this based on a measure number range. I would like to have this same functionality based on a text based category. I have this partially working within the example pbix file. I am hoping someone can help sort out how to get it working based on reference solution. 

Slicing method based on: DAX Fridays #204: Slice by the results of a measure

// https://www.youtube.com/watch?v=xO9Caya9Qxw