Forum Discussion

aishak12's avatar
aishak12
Icon for Helper IV rankHelper IV
2 years ago

How to deal with duplicate values

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. 


 

data protection
Interesting Links
Need Help
Show and Tell
Tutorial Requests

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    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)?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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