Error with table relationships

[Anonymous]

Hey everyone,

Im kinda new with Power BI, just trying to figure it out how to make this work. Here's my issue:

I got a table with sales historic data (Table A) , and another table with the current month sales (Table B). 
So basically I have a measure to get the rolling average of the historic data, this will be used as a Forecast.
But here's the catch,I need to visualize this data by account. There's some accounts that have not made any sales in the past 3 months and they suddendly make sales in the current month or maybe they didnt make any sales this month even thought they made in the past months. This affects my table in this way, its showing accounts without data  either in the forecast or in the current month. I'm only interested in showing the accounts with current month data so, Is there any possibilty to filter or making this work? Thank you in advance!
 

[parry2k · Accepted solution]

@Anonymous assuming net value and forecast amoutn current  are you columns in the table

Add following two measures and use these measures in your table visual

Sum of Net Value = SUM( Table[Net Value])

Sum of Forecast = 
SUM( Table[Forecast] ) * 
DIVIDE( [Sum of Net Value] , [Sum of Net Value] )
)