--- title: "PredictAdjustedProbability (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 --- # PredictAdjustedProbability (DMX) [!INCLUDE[ssas-appliesto-sqlas](../includes/ssas-appliesto-sqlas.md)] Returns the adjusted probability of a specified state. ## Syntax ``` PredictAdjustedProbability(, []) ``` ## Applies To A scalar column. ## Return Type A scalar value. ## 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 adjusted probability for the missing states, set the \ to NULL. The **PredictAdjustedProbability** function is a [!INCLUDE[msCoName](../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] extension to the [!INCLUDE[msCoName](../includes/msconame-md.md)] OLE DB for Data Mining specification. ## Examples The following example uses a natural prediction join to determine if an individual is likely to be a bike buyer based on the TM Decision Tree mining model, and also determines the adjusted probability for the prediction. ``` SELECT [Bike Buyer], PredictAdjustedProbability([Bike Buyer]) AS [Adjusted Probability] 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)