## How does the VARX.P function (DAX) work?

The VARX.P function (DAX) returns the variance of the entire population.

## VARX.P Formula Syntax

VARX.P(
<table>, <expression>
)

## How do you use the VARX.P function?

This function is used to calculate a value for each row in a table and displays the variance of the entire population of these values.

## Related Support Forum Posts

Dax not working
Dax Calculation question
DAX Buffer Calculation Query

## Considerations when using the VARX.P function

1. VARX.P evaluates <expression> for each row of <table> and returns the variance of <expression> assuming that <table> refers to the entire population.. If <table> represents a sample of the population, then compute the variance by using VARX.S.
2. VARX.P uses the following formula:∑(x – x̃)²/nwhere x̃ is the average value of x for the entire populationand n is the population size
3. Blank rows are filtered out from columnName and not considered in the calculations.
4. An error is returned if columnName contains less than 2 non-blank rows

## Formula examples using the VARX.P function

=VARX.P(InternetSales_USD, InternetSales_USD[UnitPrice_USD] –(InternetSales_USD[DiscountAmount_USD]/InternetSales_USD[OrderQuantity]))

= VARX.P (Sales, [Sales Amount])

## Related Course Modules 