Results 1 to 3 of 3

Thread: Only sum what is shown in table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2016
    Posts
    211
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Only sum what is shown in table

    I have some very simple data and I have created no measures whatsoever.

    I am working with 2 tables. One called project table, one called budget table.

    When we first started we dummied in a few projects and they were never removed from the project or budget table.

    I filtered them out in my project table then added all projects to my matrix/table in my powerbi visual

    when I add forecasted over/under to the matrix/table it brings in the correct values but totals them wrong. It is the obvious issue of PowerBI summing everything on the budget table not just what is shown in the matrix and I do not know how to fix because again this is not a measure I created,it is just summarizing one column from the data.

  2. #2
    New Member
    Join Date
    Dec 2016
    Posts
    17
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Only sum what is shown in table

    try a regular Pivot Table in Excel

  3. #3
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,027
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Only sum what is shown in table

    post an example of source data (two tables) and expected result
    it can be via link to the shared excel file from google drive or one drive or any other service
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •