Forum Discussion

TCatron18's avatar
TCatron18
Helper II
1 year ago
Solved

If Statement in Measure

Hello!   I've looked around but not finding a solution that works for my situation.    I am trying to add a row into a matrix that has a static value for a specific column. Below is the current s...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Add selectedvalue()

     

    IF( selectedvalue('Awards'[Sender's Sr Business Unit] ) = "xSystem Generated",

Deku's avatar
Deku
Super User
1 year ago

Add selectedvalue()

 

IF( selectedvalue('Awards'[Sender's Sr Business Unit] ) = "xSystem Generated",

TCatron18's avatar
TCatron18
Helper II
1 year ago

Deku - I get an error. 

 

  • Deku's avatar
    Deku
    Super User
    1 year ago

    The = "xSystemGenerate" should be outside of the selectedvalue brackets

  • d_m_LNK's avatar
    d_m_LNK
    Super User
    1 year ago

    Just a Parenthses in the wrong spot.  It should read like this

     

    IF(SELECTEDVALUE('Awards'[Sender's Sr Business Unit]) = "xSystem Generated", SysGen, EmpCount - [Total Mgr Count] )