57.1 DAX Formulas for PowerPivot – Chapter 12

Chapter 12 shows how to build a disconnected table (one without a relationship to other tables) that can be used to provide values to other calculations. You can insert a slicer based on the disconnected table to allow report users to select values from the table, like parameters.

The chapter provides 1.5 examples of using this technique. The first one shows how to select a USD/EUR exchange rate and see how sales would be affected. The second example starts to show how to use a “slicer parameter” to set the minimum list price of products to show in a PivotTable. This example is not finished in Chapter 12 because, in order for the measure behind the calculation to work, we must use the FILTER() function in the calculation. And that’s the topic of the next chapter.

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