Forum Discussion

Muki's avatar
Muki
Helper I
8 years ago
Solved

filter table based on duplicate values in selected columns

Hi   I'm trying to find a solution for below situation.   Add a column with amount of duplicate values based upon selected columns ( version, coverage ) For these duplicate records, only keep th...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Muki

     

    Try this calculated table

     

    Go to Modelling Tab>>>NEW TABLE

     

    Table =
ADDCOLUMNS (
    SUMMARIZE (
        TableName,
        TableName[version],
        TableName[coverage],
        "Start_Date", CALCULATE ( MAX ( TableName[start date] ), TableName[status] = "ok" )
    ),
    "ID", CALCULATE (
        SELECTEDVALUE ( TableName[id] ),
        TableName[start date] = EARLIER ( [Start_Date] )
    ),
    "Status", "Ok",
    "Count", CALCULATE ( COUNT ( TableName[coverage] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Muki

 

Try this calculated table

 

Go to Modelling Tab>>>NEW TABLE

 

Table =
ADDCOLUMNS (
    SUMMARIZE (
        TableName,
        TableName[version],
        TableName[coverage],
        "Start_Date", CALCULATE ( MAX ( TableName[start date] ), TableName[status] = "ok" )
    ),
    "ID", CALCULATE (
        SELECTEDVALUE ( TableName[id] ),
        TableName[start date] = EARLIER ( [Start_Date] )
    ),
    "Status", "Ok",
    "Count", CALCULATE ( COUNT ( TableName[coverage] ) )
)