Invoice and Payment data model

Hi BiRav ,

Thanks for reaching out to us with your problem. If I understand correctly, there are 3 tables in your model: customer dimension table, payment and invoice fact table. And you created the relationship among these three tables base on the field [Customer ID]. And now you wnat to get the number of unpaid invoices. How to identify that invoice is paid  or not? Is there any conditions need to fulfill? Could you please share your expected result with the specific examples base on the current provided data? Which invoice will be identified as Unpaid in the below screenshot? It would be helpful to find the solution. Thank you.

Best Regards