(PBIX attached) why does invoiceamount not reflect actual when supplier is selected

[Satch]

https://drive.google.com/file/d/0B_7ViRmIIPNgSVBQRTdTZzIzZHM/view?usp=sharing

see pbix^

@Vvelarde  or someone else of course 🙂

When I select supplier du I get total invoiceamount of all invoices, and not only this supplier

when I select yuc I get exactly amount of yuc

Can somebody tell me why?

[v-huizhn-msft · Accepted solution]

Hi @Satch,

Please use the [priceExcl] field in invoiceitem table, it will shows the correct result. 



When you use the [priceExcl] field in invoice table, it shows uncorrect result. Because the 'invoice' relates to 'Supplier' indirectly by unsure relationship. For example you select one value Supplier[id]->catelog[supplier.id]->variant[id], varint[product.resource.id] to filter invoiceitem by invoiceitem[product.resource.id], if you use filtered invoiceitem table effect invoice table. It can not be decided by the unigue value in 'Supplier' table.

Best Regards,
Angelia