How to Use the Power BI DAX function CONFIDENCE.NORM


CONFIDENCE.NORM is a function that calculates the confidence interval for a population mean. In other words, it helps you determine how sure you can be that your data accurately represents the population you’re studying. The function takes two arguments:

– Alpha: This is the level of significance you want to use. The default value is 0.05, which represents a 95% confidence interval.

– Standard_dev: This is the standard deviation of the population.

Once you’ve provided these two pieces of information, the function will return the confidence interval for the population mean.

How to Use CONFIDENCE.NORM in Power BI

Using CONFIDENCE.NORM in Power BI is relatively straightforward. Here’s how to do it:

1. Open Power BI and load the data set you want to analyze. Make sure you have a measure that calculates the population mean you want to analyze.

2. Create a new measure using the following syntax:

`CONFIDENCE.NORM(alpha, standard_dev, COUNT(column_name))`

Replace alpha and standard_dev with the appropriate values, and replace column_name with the name of the column that contains the data you want to analyze.

For example, if you want to calculate the confidence interval for the average sales amount for a particular product, you might use the following formula:

`CONFIDENCE.NORM(0.05, AVERAGE(Sales[Amount]), COUNT(Sales[Product]))`

This formula uses an alpha value of 0.05 (which represents a 95% confidence interval), the average sales amount for the product, and the count of the product sales.

3. Once you’ve created your measure, you can use it in your visualizations to help you understand how confident you can be in the data you’re seeing.

Understanding the Results

Once you’ve used CONFIDENCE.NORM to calculate the confidence interval for your population mean, you need to understand what the results mean. Essentially, the confidence interval gives you a range of values that you can be reasonably sure contains the true population mean.

For example, let’s say you use CONFIDENCE.NORM to calculate the confidence interval for the average sales amount for a particular product. The result might be something like this:

– Lower bound: $750

– Upper bound: $950

This means that, based on your data, you can be 95% confident that the true population mean falls somewhere between $750 and $950. In other words, if you were to repeat your analysis multiple times, you would expect to see results within this range 95% of the time.

Using the CONFIDENCE.NORM function in Power BI can be incredibly useful when you’re working with data sets and need to understand how confident you can be in the results you’re seeing. By calculating the confidence interval for your population mean, you can get a sense of how accurate your data is and how much you can trust your conclusions. So if you’re working with data in Power BI, be sure to give this function a try!

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

6-8 Jun 23 (London or Online)
8-10 Aug 23 (London or Online)
24-26 Oct 23 (London or Online)

Contact Us


    Your Name (required)


    Email (required)


    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)