As a dataset is expanded to support more dimension and fact tables, advanced analytics, and more business users, it can be necessary to compromise certain objectives to deliver others. A common example of this is the implementation of date intelligence measures. For instance, five DAX Measures with their own date intelligence calculation (for example, Year-to-Date, Prior Year-to-Date), may be created for each existing measure thus causing a dataset with 20 measures to contain 120 measures. Since Power BI does not currently support display folders for measures, this can negatively impact the usability or user interface objective. Another example is the performance of complex DAX Measures relative to the scale of the dataset. ...
Competing objectives
Get Mastering Microsoft Power BI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
