Definitive Compare Two or More Rows

[disipebr]

Sorry for my basic question.

I need to identify a data in the IC column that repeated in the same column but considering another Type (Column Type).

Once identified this IC twice or more, I need filter only those repeated.

I tried many different ways to do this but unsuccess.

In my last try, I created 2 linked tables on Editor Query, each one with a filter By Type. I need compare my master table with each one linked table.

If any way to do that easier without linked tables using filters in calculated field, please tell me.

Can you hlep me in this issue ?

Image

[v-piga-msft · Accepted solution]

Hi @disipebr,

You could create the measures with the formula below and use measure2 as the visual level filter.

Measure = CALCULATE(COUNT('table'[IC]),ALLEXCEPT('table','table'[IC]))

Measure 2 = IF([Measure]>=2,0,1)

Then you could create the table like below.

If you still need help, please share your desired output so that we could help further on it.

Best  Regards,

Cherry