Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
62 | |
61 | |
60 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |