57.1 DAX Formulas for PowerPivot – Chapter 15

Two aspects of DAX measures that give them their power are:

  1. Their calculations are independent of particular data values
  2. Their calculations can be applied in any filter context

As you start to do more with DAX measures, however, you find that you need to change calculation behavior based on the above 2 situations. Examples are avoiding division by zero and correctly calculating values for contexts where only one value is present in the filter context, respectively. The functions introduced in Chapter 15 (IF(), BLANK(), ISBLANK(), HASONEVALUE(), SWITCH()) help you craft calculations for these types of situations. In addition, the VALUES() function is introduced. VALUES() is interesting because it can return either a single value (scalar) or multiple values (table) depending on context.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s