Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Set conditional formatting between fields

Hi, I would like to change the color of a row if 2 field have the same name for example if I have the table (first name, last name, age) I would like to color of the same color row who has the same ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    These are two separate measures.

    The first one:

    Measure = SELECTEDVALUE(Table1[FirstName])

    The Index measure:

    Index = 
RANKX(ALLSELECTED(Table1),[Measure],,ASC,Dense)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

What is the error?

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-yulgu-msft ,

 

It say that this syntax is incorrecthere is my measure  as I follow yours  I tried to put ";" instead of "," inside the RANKX function but it's still not working

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    These are two separate measures.

    The first one:

    Measure = SELECTEDVALUE(Table1[FirstName])

    The Index measure:

    Index = 
RANKX(ALLSELECTED(Table1),[Measure],,ASC,Dense)

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-yulgu-msft ,

       

      Thank you very much, you helped  me a lot solving my problem