DAX selectedvalue to return a column

[Anonymous]

Hi I am seeking a help with a DAX that 

1) when Filter PC, return DAX = EAM

2) when Filter Print, return DAX = Print Lead Rep

Issue : When I select PC, it incorrectly returns Prit Rep

I wrote my DAX = IF(SELECTEDVALUE(lookupPdt[L2 Segment ]) = "PC", lookupNAL[EAM],lookupNAL[Print Lead Rep])

[Anonymous]

Hi

You can try the following

DAX =
SWITCH (
    TRUE (),
    SELECTEDVALUE(lookupPdt[L2 Segment ]) = "PC", lookupNAL[EAM],
    SELECTEDVALUE(lookupPdt[L2 Segment ]) = "Print", lookupNAL[Print Lead Rep],
      blank())

If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[Anonymous]

unfortunately the DAX, when I select "Print" or "PC" return blanks