Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
5 years ago
Solved

Measure total is wrong

Hi ,  I am trying to get measures as below;   Total Costs = CALCULATE( sum(Transactions[ACTUAL_AMOUNT]), FILTER(Transactions,Transactions[Activity_code_Num]>=3000 && Transactions[Activity...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Priya2007 , Try a measure like

    sumx(summarize(Table, Table[Product_no], Table[ResponsibilityCode], Table[Fiscal Period],"_1",IF( SELECTEDVALUE('Calendar'[Financial Period Number]) >= SELECTEDVALUE(Transactions[FISCAL_PERIOD]),[Total Costs],0)),[_1])

amitchandak's avatar
amitchandak
Super User
5 years ago

Priya2007 , Try a measure like

sumx(summarize(Table, Table[Product_no], Table[ResponsibilityCode], Table[Fiscal Period],"_1",IF( SELECTEDVALUE('Calendar'[Financial Period Number]) >= SELECTEDVALUE(Transactions[FISCAL_PERIOD]),[Total Costs],0)),[_1])