Forum Discussion

Radhika2605's avatar
Radhika2605
Icon for Helper II rankHelper II
5 years ago

Help with a visual

Hi Everyone!   I am working on a Restaurant data and I have three types of ratings - Overall, Service and Food Ratings. I have created three different visuals currently to show the ratings per city...
Need Help
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Can't you just create measures along the lines of:

Overall rating = SUM(Rating[Overall_rating])

?

Radhika2605's avatar
Radhika2605
Icon for Helper II rankHelper II
5 years ago

PaulDBrown 

Sadly no as this is the rating of restaurant out of 3. I want the rating to come as a legend like in the visuals. I want to count the number of restaurants in each city which are given a rating of 0, 1 and 2. 

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    So what are you using in the original visuals?