Slicer with measures ?

Hi,

You could take this approach.

Create a table called Measures. The contents will be 

MeasureName , MeasureID as column names

The rows will be

Gross Revenue , 1

Net Revenue , 2

Create a measure in the data model as follows :

Showvalue=switch (TRUE,
Min ( Measures[MeasureID] ) = 1,
( [SalesQty]  ),                            /* replace this by your fomula for Gross Revenue or if already exists put that measurename */
Min ( Measures[MeasureID] ) = 2,
( [Sales] ) )                              /* replace this by your fomula for Net Revenue or if already exists put that measurename */

Now create a slicer with Measure table column MeasureName .

In the chart or table , use the measure Showvalue as your values column to chart or display in table.

and you will have the results.

Best

Cheenusing