Only sum what is shown in table

Craigc3814

Board Regular
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.
 

sandy666

Well-known Member
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
 

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top