Using Measure as a Slicer

[CSMcVey]

I have a measure in that is 'Exp%Rev' - I want to include a slicer where the options are 1) 0%-25%, 2) 26%-50%, 3) 51%-75%, 4) 76%-100%, 5) 100%+. When one of these slicer options is selcted the table will be filtered to include records where the 'Exp%Rev' fall into the selected range.

I believe the solution is related to disassociated slicers but in all honesty I have not understood articles in regards to those.

Thanks in advance

 

[Tianbas]

Ok here the general idea about disconnected slicer and using measures as slicer

First you need to create a table with 2 columns

ID Select
1 0%-25%
2 26%-50%
3 ....
4
5

Use linked table to get in in your data model go to your pivot and refresh. Now you can add the this as slicer which will do nothing at this point.

Second you need to create different measures that do the calculation that you want to show for the 5 different options of your slicer

Third You need one measure that identifies what is selected in the slicer and chose which of the 5 measures to show. If you are in EXCEL 2013 you can take a SWITCH formula if your are in 2010 you have to use a nested IF
To read out the slicer I would recommend a MAX or MIN to have no issues if somebody selects more than one slicer

=IF(MAX('Selected Measure'[ID])=1,Table1[Measure1],IF(MAX('Selected Measure'[ID])=2,....