Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error with table relationships

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!
 

Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    6 years ago

    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] )
)

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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] )
)