Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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