summarize issue

[Priya2007]

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.

[amitchandak]

@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])))