Disconnected Table Example

Create an empty table to be used for Report Measures:

_Report Measures =FILTER ( {1}, FALSE ) 

Create a disconnected table to be used in a slicer to select the measure you want to view:

MeasureToView =

DATATABLE(

"MeasureName", STRING,

"Ordinal", INTEGER,

{

{ "Units", 1 },

{ "Sales", 2 },

{ "Avg Sales", 3 },

{ "Trans", 4 },

{ "Avg Trans", 5 },

{ "Avg Check", 6 }

}

)

Get the measure based on the selection in the slicer:

_Default Measure Selection =

VAR MeasureName =

SELECTEDVALUE('MeasureToView'[MeasureName])

VAR Result = SWITCH(

MeasureName,

"Units", [Reporting Units],

"Sales", [Sales],

"Trans", [Transactions],

"Avg Sales", [Average Sales],

"Avg Trans", [Average Transactions],

"Avg Check", [Average Check]

)

RETURN Result