Forum Discussion

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
8 years ago

Measure for Scatter Plot Category

Hello All,   Seems like this has probably been hashed out--and perhaps solved.  I didn't see anything and thought it might be a straightforward Yes/No and perhaps a "here's how."   I have a scatt...
Need Help
ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
8 years ago

That's a good idea.  I've not created a column before...just scalars.  Are you thinking of SelectColumn?  And with SelectColumn, do the relationships from the base table stay in-place when it is executed?  Thanks, Tom

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Tom,

 

If they are all scalars, I think the calculated column could be the best solution. Please give it a try. If you use SELECTCOLUMNS in a measure, that still won't work.

 

Best Regards,

Dale

  • ThomasDay's avatar
    ThomasDay
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    v-jiascu-msft Oh, I get it now...I'll try that.  Am traveling a bit and will report back when I give it a try.  Thank you, Tom

    • ThomasDay's avatar
      ThomasDay
      Icon for Impactful Individual rankImpactful Individual
      8 years ago

      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