Power Bi line items details not appearing well

[Anonymous]

Hi Team, 

i am facing a issue like granular level data. 

i want to see all 3 records without invoice_line_number. 

this last 2 records are not duplicate, but when i involveInvoice_line_number i can see 3 if not i can see 2 records. 

can anyone help.

[Anonymous]

Hi @Anonymous,

Perhaps you can take a look the following blog about handle measure formula with multiple aggregations if it suitable for your granular level issues:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng