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] ) )
)
    • Muki's avatar
      Muki
      Helper I
      8 years ago

      Thank you very much Muhammed Zubair_Muhammad!

      • Muki's avatar
        Muki
        Helper I
        8 years ago

        Hi Zubair_Muhammad

        I have an additional question about the resolution you provided here.

         

        So in the summary part you filter the table based on version/coverage and the latest start date.

        But then as part of 'add columns' you again mention the latest start date? I would like to know whether we can just add columns in our result table (because in my real example I have a lot more columns) without mentioning any expressions.

        Basically, filter the table on some columns, create extra calculated columns and take over the values of other columns in my original table.

         

        Is that possible?

        thanks!

        Muki