Power BI Total Incorrect

Question

Hi,I created a measure if actual isblank, then use LBE. but the total is incorrect.&nbsp;LBEorACT = if (ISBLANK(sum(table1[Actual])),sum(table2[LBE]),sum(table1[Actual])).The result seems correct, except for the total.&nbsp;I have 3 tables. table 1 contains actual, table 2 contains LBE, table 3 is calendar&nbsp;example:Month&nbsp; &nbsp; &nbsp; &nbsp; Actual&nbsp; &nbsp; LBE&nbsp; LBEorAct&nbsp; &nbsp;CumAct&nbsp; CumLBEorActJan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Apr&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20===&gt; this should be 70

amirabedh · Answer

You are having an issue with the total because the formula is not accounting for the context of the calculation.
The missing part here is the aggregation over time&nbsp; so you may need TOTALYTD() :
&nbsp;
LBEorACT = IF(ISBLANK(SUM(table1[Actual])),TOTALYTD(SUM(table2[LBE]), 'table3'[Date]),TOTALYTD(SUM(table1[Actual]), 'table3'[Date]))
Can you also share your PBI file to have more info about your situation ?

gigi2909 · Answer

tried, but didnt work. got the same result.I have a table for actuals, another for LBE. all I want is a table to show LBEorActual&nbsp;For example, if there is actual$ for Jan only, then Feb-Dec use LBE$. So I can have Full Year Forecast of Actual and LBE.&nbsp;Month&nbsp; &nbsp; &nbsp; &nbsp; Actual&nbsp; &nbsp; LBE&nbsp; LBEorAct&nbsp; &nbsp;CumAct&nbsp; CumLBEorActJan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Apr&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20===&gt; this should be 70

amirabedh · Answer

Can you please share your PBI file?

Forum Discussion

Power BI Total Incorrect

3 Replies

Related content

Incorrect turnover total

Measure Total Incorrect

Matrix Totals Incorrect

Incorrect total

Incorrect Total