The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks for replying Jihwan but I was able to figure it out by creating a new table using Summarize.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
85 | |
75 | |
55 | |
46 |
User | Count |
---|---|
135 | |
127 | |
78 | |
64 | |
63 |