--- title: "PredictSupport (DMX) | Microsoft Docs" ms.date: 06/07/2018 ms.prod: sql ms.technology: analysis-services ms.custom: dmx ms.topic: conceptual ms.author: owend ms.reviewer: owend author: minewiskan --- # PredictSupport (DMX) [!INCLUDE[ssas-appliesto-sqlas](../includes/ssas-appliesto-sqlas.md)] Returns the support value for a specified state. ## Syntax ``` PredictSupport(, []) ``` ## Applies To A scalar column. ## Return Type A scalar value of the type that is specified by *\<*scalar column reference*>*. ## Remarks If the predicted state is omitted, the state that has the highest predictable probability is used, excluding the missing states bucket. To include the missing states bucket, set the \ to **INCLUDE_NULL**. To return the support for the missing states, set the \ to NULL. > [!NOTE] > The support values are calculated differently or might have a different interpretation depending on the model type that you are querying. For more information about how support is calculated for any particular model type, see the individual algorithm type in [Mining Model Content (Analysis Services - Data Mining)](https://docs.microsoft.com/analysis-services/data-mining/mining-model-content-analysis-services-data-mining). ## Examples The following example uses a singleton query to predict whether an individual will be a bike buyer, and also determines the support for the prediction based on the TM Decision Tree mining model. ``` SELECT [Bike Buyer], PredictSupport([Bike Buyer]) AS [Support], From [TM Decision Tree] NATURAL PREDICTION JOIN (SELECT 28 AS [Age], '2-5 Miles' AS [Commute Distance], 'Graduate Degree' AS [Education], 0 AS [Number Cars Owned], 0 AS [Number Children At Home]) AS t ``` ## See Also [Data Mining Extensions (DMX) Function Reference](../dmx/data-mining-extensions-dmx-function-reference.md) [Functions (DMX)](../dmx/functions-dmx.md) [General Prediction Functions (DMX)](../dmx/general-prediction-functions-dmx.md)