Forum Discussion

RyanLMoran's avatar
RyanLMoran
Icon for Helper I rankHelper I
4 years ago

Sum column based off of text data

Hello All:

 

     Quick question that I think will be relatively easy for sum.  I'm pulling in some data and transformed that data to only show me courses that have the "First Grade" name in them.  That way, I can ensure that I'm getting only the first grade courses and which teachers are teaching those courses.  But, I want to sum that so that I can have a Column that will show me Teacher Emily G is teaching 8 first grade courses.  Just to make it easier to get a quick look at what the load is for courses on that teacher.  This is listing out the courses but I need it summed to a total number.  I'm goinng to do the same thing to have a Kindergarten, Second Grade, Third Grade, etc... total columns for each grade.  That way we can see that Emily is teaching 2 Kindergarten courses,  8 First Grade Courses, 0 Second Grade courses, etc... and then a total in sum at the end to show 22 total elementary courses being taught by her.  Thank you!

 

 

17 Replies

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User

    Should be easy enough, can you please paste some data to work with? (not a screen shot)

     

    • RyanLMoran's avatar
      RyanLMoran
      Icon for Helper I rankHelper I

      I'd be happy to.  Would I just attach the PBIX file that I currently have?

      • KNP's avatar
        KNP
        Icon for Super User rankSuper User

        If the data is not sensitive, yes. You'll have to share a link to google drive or similar as attaching files is restricted. Alternatively, you could just paste some sample data directly.

         

        Did you see the PBIX I attached earlier? Does this help?

         

  • Hi, 

    please provide not an image of data but some sample data in a format one can use.

     

    • RyanLMoran's avatar
      RyanLMoran
      Icon for Helper I rankHelper I

      Sure, like the PBIX file or how should I attach that?

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User

    There are many ways you can approach this depending on the data and model complexity.

    I've attached a simple example PBIX.

    Have a look and let me know if you have any questions.