Forum Discussion
Total of Particular Data
I am completely new to Power BI and I am trying to figure out how it all works. I cannot seem to figure out how to get the data I need. I have a CSV file that has a list of wineries in one column and the state they are in, in another. What would I need to add to the data in Power BI in order to create a visualization that shows how many wineries are in each state?
For example:
I have a column that just shows like this:
California |
California |
Oregon |
Oregon |
California |
Oregon |
Oregon |
Oregon |
Oregon |
California |
California |
California |
California |
California |
Oregon |
California |
Washington |
California |
Washington |
California |
Washington |
California |
Washington |
New York |
Washington |
California |
California |
Oregon |
California |
California |
California |
Oregon |
Oregon |
California |
California |
Oregon |
California |
California |
California |
California |
California |
California |
California |
I am trying to figure out how to create a new column that will show me how many California, Oregon, ect.
Hi asonnentag ,
Please have a try.
Create a measure.
Measure = CALCULATE ( COUNT ( 'Table'[name] ), FILTER ( ALL ( 'Table' ), 'Table'[name] = SELECTEDVALUE ( 'Table'[name] ) ) )If I have misunderstood your meaning, please provide screenshoots with some sample data and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi asonnentag ,
Please have a try.
Create a measure.
Measure = CALCULATE ( COUNT ( 'Table'[name] ), FILTER ( ALL ( 'Table' ), 'Table'[name] = SELECTEDVALUE ( 'Table'[name] ) ) )If I have misunderstood your meaning, please provide screenshoots with some sample data and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.