Forum Discussion

NSBS's avatar
NSBS
Helper I
4 years ago
Solved

Row Comparison and Detecting Different Corresponding Values

Hi Experts,   Kindly help to give idea on how should I compare below row to detect which ID have more than 1 names. My Original Dataset only consists of Column ID and Name. And I want the result t...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Expected result CC =
VAR _condition =
    COUNTROWS (
        SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Name] )
    ) = 1
RETURN
    IF ( _condition, "ID per 1 name", "ID have more than 1 names" )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Expected result CC =
VAR _condition =
    COUNTROWS (
        SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Name] )
    ) = 1
RETURN
    IF ( _condition, "ID per 1 name", "ID have more than 1 names" )
NSBS's avatar
NSBS
Helper I
4 years ago

Hi Jihwan_Kim ,

 

Currently I'm in the need of the M code for this row comparison as well. I have try to create it but no output.

Kindly help on this matter.

 

Thank you.