VARX.P

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the variance of the entire population.

Syntax

VARX.P(, )


Parameters






Term
Definition






table
Any DAX expression that returns a table of data.




expression
Any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).






Return value


A number with the variance of the entire population.


Remarks


    

  • VARX.P evaluates  for each row of 
     and returns the variance of  assuming that 
     refers to the entire population.. If 
     represents a sample of the population, then compute the variance by using VARX.S.
  • VARX.P uses the following formula:
    

    ∑(x - x̃)2/n
    

    where x̃ is the average value of x for the entire population
    

    and n is the population size
    

  • Blank rows are filtered out from columnName and not considered in the calculations.
    

  • An error is returned if columnName contains less than 2 non-blank rows
    

  • 

    This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
    

    • Example
    The following example shows the formula for a calculated column that calculates the variance of the unit price per product, when the formula is used in the Product table
    = VARX.P(InternetSales_USD, InternetSales_USD[UnitPrice_USD] –(InternetSales_USD[DiscountAmount_USD]/InternetSales_USD[OrderQuantity]))

    
			
			
			 
		
	 
		
	
		
    
			
    
			
      
				
    • 
			
				Last updated on 
			
		
      •