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.