Forum Discussion
Radhika2605
5 years agoHelper II
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...
Radhika2605
4 years agoHelper II
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
4 years agoCommunity Champion
Can't you just create measures along the lines of:
Overall rating = SUM(Rating[Overall_rating])
?