DIVIDE([Invoice $] , CALCULATE([Invoice $], REMOVEFILTERS(Invoices[Invoice])))
Correctly displays only relevant invoice numbers with percent of grand total value
[Invoice $] - CALCULATE([Invoice $], REMOVEFILTERS(Invoices[Invoice]))
Returns all invoice numbers even if they do not have an [Invoice $] value.
I tried the dax measure:
[Invoice $] - CALCULATE([Invoice $], REMOVEFILTERS(Invoices[Invoice]))
How can I efficiently only return invoice numbers with an invoice $ value?