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 DAX = IF(SELECTEDVALUE(lookupPdt[L2 Segment ]) = "PC", lookupNAL[EAM],lookupNAL[Print Lead Rep])

 

2 Replies

  • 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