I am very new in PowerBI and I need help with calculations.
From the table below (this is a small part of the table)
From this table, I need to calculate total hours per Project_ID based on Task_ID planned hours. The difficult part for me is that Task_ID with the same name should be included once in the hour's calculation for Project_ID. I mean that for instance for Project_1 final result should be 15hours instead of 70hours. And also I need to calculate total progress for the Project_ID issue here is that some fields are missing value. So how can I ignore it or include as 100% in the calculation?