Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Need help on below

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 ...

DAX

FreemanZ

2 years ago

hi Anonymous ,

try to plot the mentioned columns with a measure like:

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

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

it worked like:

FreemanZ

Super User

2 years ago

hi Anonymous ,

try to plot the mentioned columns with a measure like:

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

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

it worked like:

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