Using Measure to calculate list ?

[Keith011]

Hi there!

Is it possible to use a Measure to calculate the count of each values in a column? (The table below is just one of a column in my raw data table)

For example,

Red = count of 5

Blue = count of 3

Green = count of 3

Black = count of 2

Purple = count of 3

color names

red

blue

green

green

green

blue

black

black

purple

red

red

red

red

purple

purple

blue

[Anonymous · Accepted solution]

Hi @Keith011 ,

I already helped you move this post to Power BI Desktop forum.

Here's the solution. You can create a measure using COUNT function.

Count = COUNT('Table'[color names])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Use the DISTINCTCOUNT function, and use the colors as the dimension.

-- Nate

[nickvanmaele]

This is probably a DAX / Power BI question which you could post in the Power BI forum instead of the Power Query forum?