Forum Discussion

YerlaSDU's avatar
YerlaSDU
Icon for Helper I rankHelper I
2 years ago
Solved

How to show only duplicate column in visual

Hi Folks,

 

I have Table and 2 columns.

How to show only dublicate values by Description column in Manufacturer Column?

f.e: IMPELLER description has 3 manufacturer values

for some reason, this code doesn't help

Duplicate =

IF (

    COUNTROWS ( FILTER ( 'DCMM MaterialsManagement', 'DCMM MaterialsManagement'[DESCRIPTION] = EARLIER ( 'DCMM MaterialsManagement'[MANUFACTURER] ) ) )

        > 1,

    "YES",

    "NO"

)
Need Help
  • Chakravarthy's avatar
    Chakravarthy
    2 years ago

    Hi YerlaSDU 

     

    Please try - 

    Duplicate =
    IF (
    COUNTROWS ( FILTER ( 'DCMM MaterialsManagement', 'DCMM MaterialsManagement'[DESCRIPTION] = EARLIER ( 'DCMM MaterialsManagement'[DESCRIPTION] ) ) )
    > 1,
    "YES",
    "NO"
    )

1 Reply

  • Chakravarthy's avatar
    Chakravarthy
    Icon for Resolver II rankResolver II
    2 years ago

    Hi YerlaSDU 

     

    Please try - 

    Duplicate =
    IF (
    COUNTROWS ( FILTER ( 'DCMM MaterialsManagement', 'DCMM MaterialsManagement'[DESCRIPTION] = EARLIER ( 'DCMM MaterialsManagement'[DESCRIPTION] ) ) )
    > 1,
    "YES",
    "NO"
    )