Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a table that has Cost by Type but some Types have multiple Costs associated with them. I want to sum up the total cost for each unique Type, and then count the Total cost values based on a range of values (0-1000, 1001-10000, 10,001+, etc). I have used CountRows and this works if I want to count each individual item, but I can't figure out how to count the summed total. Thank you for the help!
Hi, @K7R-RS8-04
Please share your sample pbix file's link here, together with how your desired outcome looks like, then I can try to look into it to come up with a more accurate solution.
Thanks.
Thanks for replying Jihwan but I was able to figure it out by creating a new table using Summarize.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |