How to deal with duplicate values

[aishak12]

All, 

I have multiple records for projects which contain the same value for "Labor Budget" repeated while "Labor Billed" is unique.

I want to show on all my visuals only 3,475,950.02 for this project instead of summarizing the entire project. I have thousands of projects which I only want to show the first value of labor budget and not the total. 

[v-xuxinyi-msft]

Hi @aishak12 

Thanks for the reply from @Ashish_Mathur  and @lbendlin .

If your problem is not solved, could you tell me what criteria are used to obtain "the first value"? Is it the earliest or the largest value of the date?

Best Regards,
Yulia Xu

[Ashish_Mathur]

Hi,

So do you want to create another column in the Table with 3,475,950.02 for that project OR do you want to show that value in a Table visual (which will only have one row for each project)?

[lbendlin]

Leave your data as is and then in DAX use the MAX() aggregation for that column.