Forum Discussion
Power BI Total Incorrect
Hi, I created a measure if actual isblank, then use LBE. but the total is incorrect. LBEorACT = if (ISBLANK(sum(table1[Actual])),sum(table2[LBE]),sum(table1[Actual])). The result seems correct,...
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
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.
Month Actual LBE LBEorAct CumAct CumLBEorAct
Jan 10 20 10 10 10
Feb 20 20
Mar 20 20
Apr 20 20
Total 10 80 20===> this should be 70
Can you please share your PBI file?
