Multiple Assignments Shown Due to Multiple Resources in a Table Visual

[amaoa]

Hello,

I created a table to list assignments. But whenever the assignment has two or more resources, it shows up twice or based on the number of resources assigned to the assignment in the table. I know this makes sense as not all resources might finish assignment at the same time. Any idea how I can make it show just once? This is throwing off the count of assignment completed or ontrack. I also don't want to show it twice in the table. See example below. Data source is from Project Online. 

[amaoa]

I found out. I went to transform data. Right-click the Mapping Name column and select Delete Duplicate Data. Thank you all.

[v-deddai1-msft]

Hi @amaoa , 

I'm glad that you solved the problem by yourself. Would you please accept your own reply as answer to help the other members find it more quickly?

Best Regards,

Dedmon Dai

[dedelman_clng]

Hi @amaoa 

Since the data in the two rows is different aside from the task name, you have to apply some kind of summarization to the date fields (and possibly the % complete) to knock it down to 1 row.

Summarizations available for dates are Last (Latest), First (Earliest), and Count. Which one you use depends on what you are trying to show.

Hope this helps

David