Forum Discussion

mina97's avatar
mina97
Icon for Helper III rankHelper III
3 years ago
Solved

unique vales based on

i have the following data    Fisrt name last name email degree payment  ID jack Eden  Eden exapmle.com bachelor 250$ 2160003021 lora Teigen  Teigen example.com bachelor 340 ...
  • ERD's avatar
    ERD
    3 years ago

    mina97 , I now get what you wanted in your code. 

    So, create a calculated column in your table:

    name unique =
VAR same_names =
    CALCULATETABLE (
        SUMMARIZE ( Specialists, Specialists[ID], Specialists[First_Name] ),
        ALLEXCEPT ( Specialists, Specialists[First_Name] )
    )
VAR ranking = RANKX ( same_names, Specialists[ID],, ASC, DENSE )
VAR blanks = REPT ( UNICHAR ( 8204 ), ranking - 1 )
VAR res = Specialists[First_Name] & blanks
RETURN
    res

    And use this column for the x-axis of your visual:

     

mina97's avatar
mina97
Icon for Helper III rankHelper III
3 years ago

hi SamInogic  i appreciate your help 

but jack who's id is 2160003021 had 2 payemnts 250$ and 600$ as 2 seperated rows but identical columns inputs except for payment column 

and i need the graph to show that this jack got 850$ as a total payment hence, the index method is not useful in this case. 

please help me and Thank you for your response