Forum Discussion

K7R-RS8-04's avatar
K7R-RS8-04
Frequent Visitor
5 years ago

Count rows after summing using a range of values

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!

Need Help

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    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.

    • K7R-RS8-04's avatar
      K7R-RS8-04
      Frequent Visitor
      5 years ago

      Thanks for replying Jihwan but I was able to figure it out by creating a new table using Summarize.