Forum Discussion
Solved
Table Summary Showing Incorrect Total
Hello, I have been trying to create a measure that will allow me to look at a data source (actual revenues & expenses) and return the total if there is data for that month and otherwise return th...
I belive this is a data lineage problem. Once you reference the BudgetOrActualTotal table you've created, it doesn't seems to identify the original column on the data model to filter your measure. I think you could try the following:
Projection Using Budget = VAR BudgetOrActual = IF( ISBLANK( [Total Actual] ), [Total Budget], [Total Actual] ) RETURN IF( HASONEVALUE( Dates[MonthName] ), BudgetOrActual, SUMX( VALUES(Dates[MonthName] ), IF( ISBLANK( [Total Actual] ), [Total Budget], [Total Actual] ) ) )
I belive this is a data lineage problem. Once you reference the BudgetOrActualTotal table you've created, it doesn't seems to identify the original column on the data model to filter your measure. I think you could try the following:
Projection Using Budget =
VAR BudgetOrActual = IF( ISBLANK( [Total Actual] ), [Total Budget], [Total Actual] )
RETURN
IF( HASONEVALUE( Dates[MonthName] ),
BudgetOrActual,
SUMX( VALUES(Dates[MonthName] ), IF( ISBLANK( [Total Actual] ), [Total Budget], [Total Actual] ) ) )Anonymous This is perfect! After a few quick tests my total is adding up exactly as I expected it would. Thank you so much for the quick response!!!
