- Tiny IMDB Data Model Introduction
- Build the Tiny Data Model
- Get Ratings from Tiny
- Get Other Tables
- Tiny MeasuresIMDB
- Tiny IMDB Average Rating for each Person
- Tiny IMDB Average Rating for each Genre
What is the average rating for each of the genres? Does the Comedy genre rate higher than the Documentary genre? Let’s create a new Measure and use the Calculate function. Some titles are in many genres. If a title is in the Comedy genre and the Adventure genre and gets a rating of 6.8, then the Comedy and Adventure genres get 6.8.
This post is in a series of posts, so it is suggested to read the posts in order because each post builds from the previous one. Please have a look at the previous post to see how to set up a Measure.
=CALCULATE(AVERAGE(tbltitles[averageRating]),tbltitleGenresLink,tblGenresLookup)