Forum Discussion
Using Measure to calculate list ?
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 |
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.
3 Replies
This is probably a DAX / Power BI question which you could post in the Power BI forum instead of the Power Query forum?
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.
