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