Adding an additional column to a table with an existing measure breaks it

[hobosapien]

I have a table with the columns 'artist_name' and 'album_name'. I created a simple measure to count the number of times an album was played and then used the TopN visual filter. The first image is the result.

Count Album Name = COUNT(SpotifyExtended[album_name])

I then added artist_name thinking I would be able to maintain the topN album_name listing but with the artist name right next it. However it expands out the album name mulitple times as you can see in the screenshot below. Why is this? And how can I show the singular artist_name values next to the TopN album_name list?

[hobosapien · Accepted solution]

I realized that the data was displaying properly as there were multiple artists per album. 

[ryan_mayu]

@hobosapien 

Here is a workaround for you. I did test for top 3

create a measure

TOP 3 =

VAR _tbl=SUMMARIZE(ALL('Table (2)'),'Table (2)'[id],"sum",sum('Table (2)'[value]))

var _tbl2=FILTER(ADDCOLUMNS(_tbl,"rank",rankx(_tbl,[sum],,DESC)),[rank]<4)

VAR _LIST=CONCATENATEX(_tbl2,[id],",")

RETURN IF(CONTAINSSTRING(_LIST,MAX('Table (2)'[id])),1,0)

and add this measure the visual and set to 1

pls see the attachment below