DAX Function Guide

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.

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