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,                      ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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])))