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,...
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"
    )

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