I am developping a Project management tool with
* SharePoint lists for Projects and Project Tasks
* Power Automate for workflows and Approvals
* Power BI for KPIs and reporting.
I would like to Distinct Count all pending tasks each time a task is created or modified and store this info (ammount of tasks pending) in the Projects list so that I can see it in the SharePoint list.