Measure total is not correct

[Priya2007]

Hi ,

I am using below measure :

Actuals = CALCULATE(sum(Transactions[ACTUAL_AMOUNT]),

Filter(Transactions,

SELECTEDVALUE('Transactions'[FISCAL_PERIOD])<=SELECTEDVALUE('Date'[Financial Period Number])),

Filter (Transactions,Transactions[Activity Code Num] >= 3000) ,

filter (Transactions,NOT[Expense Code Num] in {606,607})

)

Two tables used in this measures are not joined.

Result 

If any one can suggest how to get the correct total for actuals would be great.

[mahoneypat · Accepted solution]

Try this expression replacing the table names with your actual ones.  It references your existing measure and should give you the right result on both the rows and the total.

New Actuals = SUMX(SUMMARIZE(Table, Table[Project No], Table2[Fiscal Period]), [Actuals])

Regards,

Pat