In our last post we created the query and the view. In this post we’ll now get to the aggregate measure. If you already had a view that you know has the data you need then obviously you would skip right to this point and create a new measure.

The point of the aggregate measure object is to actually create and link the measure and dimensions that you will use for analytics. The measure will be something you create and it will be a sum or a count of data. The dimension will be something you slice the measure by. This is the basic concepts in a star analytics schema.

Here is a quick overview.

D365 July 2017 Update 8 (7.0.4565.16211)

Once you have the measure then you can use it in Power BI desktop. From there you can published to Power.com and allow users to access it in the application. You can see how this works with the standard reports models in this post.

Cheers

Lachlan