Get startedGet started for free

IF() for formatting tables

Totals and subtotals within visualizations can be very important at providing overall characteristics of an attribute (i.e. average, total, etc.).

Unfortunately sometimes, like in the case of our previous RANKX() example in Chapter 2, providing a value in the Total/Subtotal section of table is not useful. For this example you will utilize an IF() statement along with HASONEVALUE() to provide rankings for the employees, in order to remove the value from the totals row.

If you need additional hints during any of the exercises, you can check out our cheat sheet with all DAX functions and operators used in this and the DAX functions course.

This exercise is part of the course

Intermediate DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise