Need help on below

[Anonymous]

I have a table like below 

Employee name	Group	Test Name
Ramu	Production
Arjun	Test	Arjun

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 

[FreemanZ · Accepted solution]

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]

@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]

Use Add Column?

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

[Anonymous]

Hi Tom,

Thanks for your  support

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

[Tom_Y]

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

[Anonymous]

Hi Tom,

Thanks for your time.

The data source are connected live data (data fabrication - dataset), after connected live data the new column option will not available ,see the below screenshot

Please check and share inputs how we can go head