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>
)

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.

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.
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
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