Measure for Scatter Plot Category

v-jiascu-msft Hello Dale, sorry for the tardy reply...was out of the country and off the grid.

• I have created a table which has one column--the category for the chart--created by a dax expression.  This one creates the table as specified:
  ChartCategoryTable = SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[Bed Size])

• But I want to have the column contents vary based on a slicer selection...so I tried the code below resulted in the error message:  The expression specified in the query is not a valid table expression.  Perhaps it doesn't allow for dynamic values for the created column...not sure what to do here.
  • The slicer for the table CategorySlicerVals picks from the possible categories for the chart. 

ChartCategoryTable = 
	VAR SelectedChartCategory = IF(HASONEVALUE(CategorySlicerVals[Chart Category]),SelectedValue(CategorySlicerVals[Chart Category]),"Bed Size")
	Return
	Switch (
	True(),
	SelectedChartCategory = "Bed Size",SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[Bed Size]),
	SelectedChartCategory = "Disprop Share",SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[Disprop Share]),
	SelectedChartCategory = "Freestanding",SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[Freestanding]),
	SelectedChartCategory = "Ownership",SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[Ownership]),
	SelectedChartCategory = "State",SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[State]),
	SelectedChartCategory = "Urban-Rural",SELECTCOLUMNS(MeasureReptRecNoProviders,"Category", MeasureReptRecNoProviders[Urban-Rural]),
	SELECTCOLUMNS(MeasureReptRecNoProviders,"Bed Size", MeasureReptRecNoProviders[Bed Size]))

Any ideas here??

Thanks,

Tom