Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Create measure and depend on whether it is duplicate

Dear Community,   I have data as below  JobN TransactionN New Column** J001 T001 J001 J002 T002 Duplicate TransactionN J003 T002 Duplicate TransactionN J004 T003 Duplicate...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  NickProp28 ,

     

    Here are the steps you can follow：

    1. Create calculated colunm.

    New Colunm = IF([JNC]=[TNC],[JobNumber],"Duplicate")

    2. Result.

    You can downloaded PBIX file from here.

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  NickProp28 ,

 

Here are the steps you can follow：

1. Create calculated table.

TNC = CALCULATE(COUNT('Table'[TransactionNumber]),ALLEXCEPT('Table','Table'[TransactionNumber]))
JNC = CALCULATE(COUNT('Table'[JobNumber]),ALLEXCEPT('Table','Table'[JobNumber]))

2. Create measure.

New = IF(MAX('Table'[JNC])=MAX('Table'[TNC]),MAX('Table'[JobNumber]),"Duplicate")

3. Result.

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

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

  • NickProp28's avatar
    NickProp28
    Icon for Post Partisan rankPost Partisan
    5 years ago

    Dear Anonymous ,

    Thanks for your response!
    Its work well when create the DAX and show 'Duplicate'. But I would like to create a new column and indicate all my raw data whenever is it duplicate. Is it possible to do that ? I try the code you provided, but its show all the MAX JobNumber. (Create new column will more easy for me to have a report filter)

    Here the pbix: https://ufile.io/hzdz4flh
    Thanks again for your help!