The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |