What measure or dax to have my balance due on one line only, with multiple invoice lines

[vhall836]

I have built this aging, and realized that when I have an invoice number and it has more than one line my "Balance due" is repeating itself.  Any suggestions how to have the balance due only show one the first line?

[vhall836]

Ok, no measure tht is fine.  I don't mind a new column calculated field.  My desired result is the balance would pull on one of the lines and the other would be 0.  In my first post is what it looks like now and below is what I would want it to look like.

[vhall836]

Sorry, here is a better screen shot of all the data for one invoice.  

[vhall836 · Accepted solution]

Although no-one was able to give an answer I figured one out I would share.

I created 2 columns, one with indexing by group they other a key.  I then created the same key in my 2nd table and when bringing over the balances they key maps it to one line vs all of them.

[Ashish_Mathur]

Hi,

I would prefer to write a calculated column formula in the Table to solve this.  To receive more help, share some data to work with and show the expected result.

[learninPBI5Hard]

A measure will only show one value if there is not any static column value holding/forcing measure to separate. If this is the case, there might be a field that you put as row in matrix chart to separate them.

• You can try to remove that to see if it disappears
• You can also filter out specific value the row field in matrix chart. 

Let me know if you other issue fixing this, or you can send out an example file with fake data and share the link.