undefined

[preetha_127]

Hi Team,

I have same multiple invoice id with different invoice amount.I want sum those invoice amount against one invoice.

[preetha_127]

Hi team,

I have multiple report,also i have summary of all the report.If i click one report in summary page ,it will navigate particular report.Help me..

Thanks & Regards,

Preetha

[amitchandak]

@preetha_127 , Same solution as @v-qiuyu-msft , But in case you can have more than 3 digit

Try like

New Column =

var _len = search("(",[invoice] ,,0)

return

if(_len =0 ,[Invoice],left([Invoice],_len-1)

[v-qiuyu-msft · Accepted solution]

Hi @preetha_127, 

You can create a calculated column and measure like below: 

InvoiceNew = LEFT('Table'[Invoice],3)

TotalByInvoice = CALCULATE(SUM('Table'[Invoice amount]),FILTER('Table','Table'[InvoiceNew]=MAX('Table'[InvoiceNew])))

Best Regards,
Qiuyun Yu