Forum Discussion
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 curr...
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] ) )
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] ) )