Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help on below

I have a table like below 

 

Employee nameGroupTest Name
RamuProduction 
ArjunTestArjun

Need a mesuare if group column will be test then employee name should be Arjun show under test name column  other will be blank, please share a measuare 

DAX
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi Anonymous ,

     

    try to plot the mentioned columns with a measure like:

     

    Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    "Arjun", ""
)

     

    or 

    Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    MAX(data[Employee name]), ""
)

     

    it worked like:

6 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    hi Anonymous ,

     

    try to plot the mentioned columns with a measure like:

     

    Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    "Arjun", ""
)

     

    or 

    Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    MAX(data[Employee name]), ""
)

     

    it worked like:

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      FreemanZ :-

       

      On the IF condition its taking very long time loading into the visual on the below measure (its performance issue coming)

      Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    MAX(data[Employee name]), ""
)

      Kindly check and provide if other way to develop dax 

      we will wait for your response 

  • Tom_Y's avatar
    Tom_Y
    Icon for Advocate II rankAdvocate II
    2 years ago

    Use Add Column?

    Test Name = IF('Table'[Group]="Test", 'Table'[Employee], BLANK())

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Tom,

       

      Thanks for your  support

      i have connected live connection .... required a DAX , so kindly please check and provide the details 

       

       

      • Tom_Y's avatar
        Tom_Y
        Icon for Advocate II rankAdvocate II
        2 years ago

        It's DAX. Just click "Add Column" and paste, and reivse to fit your table name/ column name..