Measure values as Slicer

[Anonymous]

Is it possible to use multiple measure values as a slicer filter?

I have 4 measures:

1. Linehaul Cost

2. Accessorial Cost

3.Total Cost

4.Misc Cost

I can only use a slicer for one measure but even then it shows as the values and not the column header. Is it possible to use a slicer to select the measure name?

[TomMartens · Accepted solution]

Hey @Anonymous ,

you can create a table that has just one column and 4 rows, namely the names of the measures.

Then you can add this column to a slicer, assuming you named the column c and the table t you can create a measure m1 like so:

m1 = SELECTEDVALUE('t'[c] , "default measure")

Create a 2nd measure m2 like so: 

m2 = 
SWITCH(
[m1]
, "default measure" , [Linehaul Cost] -- assuming that the measure [Linehaul Cost] is the default measure, if no measure is selected from the slicer
, "Linehaul Cost" , [Linehaul Cost]
, "Accessorial Cost" , [Accessorial Cost]
, "Total Cost" , [Total Cost]
, "Misc Cost" , [Misc Cost]
)

Now you can use the measure m2 in all your visuals, and it will show the value of the selected "measure" from the slicer.

Hopefully, this provides what you are looking for.

Regards,

Tom