Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX selectedvalue to return a column

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 ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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