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:

     

SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

Hi mina97 ,

Instead of custom column with DAX expression, you can try creating Index column within Power Query in order generate the unique numbers,

 

Then you can design chart with below specifications,

 

Thanks!

 

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/