Duplicate values are causing summation

[PranavKhedkar]

I have a table which contains the columns: id, Title and Rating. 'id' has unique values, 'Title' has names of movies and TV shows and 'Rating' has their IMDB score(out of 10). I want to create a clustered bar chart which shows titles of the movie or show against their ratings. The problems occurs due to duplicated values in title. If three titles are the same,for eg. 'The gift', the bar chart will add the ratings which will exceed 10. I want to show the same title with their respective scores seperately. I tried to lose the sum but the option 'Don't Summarize' doesn't show in the option

How do approach this?

[PranavKhedkar]

Thank You!

[barritown · Accepted solution]

Hi @PranavKhedkar,

Should I approach such a problem, I'd create an additional column with an alternative name and use it for my bar chart. 

Like that, for example:

DAX code in plain text:

Alt Title = 
VAR CurrentTitle = [Title]
VAR MoviesWithThisName = COUNTROWS ( FILTER ( Movies, [Title] = CurrentTitle ) )
RETURN IF ( MoviesWithThisName > 1, [Title] & " (ID " & [ID] & ")", [Title] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian