Forum Discussion

Radhika2605's avatar
Radhika2605
Helper 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
Radhika2605's avatar
Radhika2605
Helper II
5 years ago

Hi PaulDBrown ,

 

Thanks for your response. I actually made a similar measure for another visual using the same technique which you suggested. But this time the problem is that Overall, Service and Food Ratings are not measures but columns of my Ratings table. Hence I dont know how to use this. 

 

 

If you could suggest how should I change this measure so that I can get the column as these are not measures for me would be great! Appreciate your help!

 

Thanks

Radhika

 

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

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

Overall rating = SUM(Rating[Overall_rating])

?

  • Radhika2605's avatar
    Radhika2605
    Helper 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
      Community Champion
      5 years ago

      So what are you using in the original visuals?