Get sum of process and review time

[Anonymous]

Hi All,

I have two tables. One with data for users like task, processing time, processor name, reviewer name and review time. Another table is Master table with Name and team. I an trying to get Processing and review time for each user. But not getting the correct results. I linked my Master tabel(Proper Name) to Data table (Processor Name)

[V-lianl-msft]

Hi @Anonymous ,

If there is no relationship between the two tables, use the name in Table 2 then create measures like below:

Processing time = CALCULATE(SUM(Table1[Processing Time]),FILTER(Table1,Table1[Processor]=MAX(Table2[Name])))+0

Reviewd time = CALCULATE(SUM(Table1[Review Time]),FILTER(Table1,Table1[Reviewed By]=MAX(Table2[Name])))+0

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks a lot for taking ot time and proving solution. This is working if i delete the Relationship between these two table. However I will need relationship for another visual, where I am showing Team wise data. Will it be possible to get the Proceseeing and Review time keeping relationship as is. Thanks.