Forum Discussion

Shota_Xuc's avatar
Shota_Xuc
Icon for Helper I rankHelper I
2 years ago

DAX measure for finding duplicates

Hi,   I have this table in Power BI and a slicer connected to column 'Trade date'. I need a measure that finds duplicates in column 'Security ID' in time interval chosen by slicer. Can anyone help?...
Need Help
Shota_Xuc's avatar
Shota_Xuc
Icon for Helper I rankHelper I
2 years ago

DataNinja777 I simplified my table in my previous question, but my table has many columns besides 'Sequrity ID' column and I I want to find duplicates only in 'Security ID' column. Your solution does not work for tables with many columns.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Shota_Xuc ,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Shota_Xuc's avatar
      Shota_Xuc
      Icon for Helper I rankHelper I
      2 years ago

      Hi Anonymous thanks, I found solution to find duplicates and it works good, below DAX:

      Duplicate Sec ID =
      VAR CountSecID = COUNTROWS(
          FILTER(
              ALLSELECTED(DM_TRANSACTIONS_CURRENT_YEAR),
              DM_TRANSACTIONS_CURRENT_YEAR[Security ID] = MAX(DM_TRANSACTIONS_CURRENT_YEAR[Security ID])
          )
      )
      RETURN
          IF(CountSecID > 2,
          "Duplicate",
          "OK")
      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        HI Shota_Xuc,

        I'm glad to hear you find the solution and share the expression here, I think they should help other users who faced the similar scenario.

        Regards,

        Xiaoxin Sheng