Forum Discussion

MZetto's avatar
MZetto
New Member
2 years ago

Missing Total in PBI Table

I have a table with multiple number columns and some columns show totals but one is not. I want the outstanding column to show a total as well. Any idea why the table is not summing up the column outstanding?

 

Formula for Outstanding Value 

Outstanding = Fact_JobInvoices[SalesValueTotal] - Fact_JobInvoices[RecievedAmount]

 

 

Thank you

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    MZetto , In this case it should not. Bur seem like row context has been used in these measures

     

    try like

    Outstanding =

    Sumx(Values(Table[Contract Line no]), Fact_JobInvoices[SalesValueTotal] - Fact_JobInvoices[RecievedAmount])

    • MZetto's avatar
      MZetto
      New Member
      2 years ago

      Thank you for the quick reply. What do I have to put instead of "Table[Contract Line no]"?