Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
5 years ago

summarize issue

Hi All, 

I have below  measure: 

              Closing ITD Actual = CALCULATE(sum(Transactions[ACTUAL_AMOUNT]),
                                        Filter(Transactions,
                                        ('Transactions'[FISCAL_PERIOD]<=SELECTEDVALUE('Date'[Financial Period Number]))

              
WIP_closing =  SUMX(VALUES(Transactions[PROJECT_NO]),[Closing ITD Actual])

 


I want WIP_closing will show 0 in both rows as the sum of closing ITD Actual is 0 for this project_no.
 

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Priya2007 , Try like  WIP_closing = calculate(SUMX(VALUES(Transactions[PROJECT_NO]),[Closing ITD Actual]), allselected(Transactions))

     

    or

    WIP_closing = calculate(SUM(Transactions[Closing ITD Actual]), filter(allselected(Transactions),Transactions[PROJECT_NO] = max(Transactions[PROJECT_NO])))