Get startedGet started for free

Basic statistical measures

Let's explore basic statistical functions. In this exercise you will use the DISTINCTCOUNT() function to get the number of invoices, and the AVERAGE() function to calculate the average retail price.

If you lost progress, close any open reports and load 2_2_basic_statistical_measures.pbix from the Exercises folder on the desktop.

This exercise is part of the course

DAX Functions in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise