Getting the frequency of each value in a column

[GooseHelpful199]

I have a table that has a column ("Item" in the example below) that I want to produce the "Frequency" column for. Is there a way to create a column in DAX that would provide me with the numbers on the right? If not, would I need to use a measure?

I think duplicating the query and getting a count from the new table would work, but Im wondering if there is a way to do this without needing to do this.

[lbendlin]

Do a SUMMARIZE over that column with COUNTROWS. 

Also check out this new-ish function:

EVALUATE COLUMNSTATISTICS()

[cjgreene · Accepted solution]

You could use a calculated column or a measure.

For the calculated column:

Frequency =

COUNTROWS(

    FILTER(

        Table1,

        Table1[Item] = EARLIER(Table1[Item])

    )

)

The calculated measure is easier:
Frequency = COUNTROWS(Table1)