Error with Grouped Graph

[da_sour]

Hi, my name is damian and I have the following info.

Jack 10
Paul 20
Paul 10
Michael 30
Michael 20

The issue is that I have many names.

I assemble a histogram without problems. but I want that on the x-axis when it says the names, say Michael = [2], Paul [2], Jack [1], instead of just the name.

That is, the name and number of repetitions of the record

I did the concatenation, but it returns me:  Michael = [1], Paul = [1], Jack [1]

Do you know that it may be what is failing me?

I did:
n = COUNT (Table [Name])
extra = "[" & n & "]"

Table [Name] & [extra]

Where this error?

[v-chuncz-msft · Accepted solution]

@da_sour,

To get the expected result, you may use EARLIER Function to add a calculated column.

Column =
COUNTROWS ( FILTER ( Table1, Table1[Name] = EARLIER ( Table1[Name] ) ) )

[da_sour]

it works!

thanks a lot sam!

[da_sour]

Hi, my name is damian and I have the following info.

Jack 10
Paul 20
Paul 10
Michael 30
Michael 20

The issue is that I have many names.

I assemble a histogram without problems. but I want that on the x-axis when it says the names, say Michael = [2], Paul [2], Jack [1], instead of just the name.

That is, the name and number of repetitions of the record

I did the concatenation, but it returns me:  Michael = [1], Paul = [1], Jack [1]

Do you know that it may be what is failing me?

I did:
n = COUNT (Table [Name])
extra = "[" & n & "]"

Table [Name] & [extra]

Where this error?