Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hide/Remove row based on criteria

I am working on a change management dashboard for my company, and I am trying to create an automated process to hide/remove rows once all of the tasks related to the change have a complete status AND...
Need Help
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    You shouldn't need to use VALUE with the measures.  That just converts strings to numerical values.  If the status number measure actually returns "4" instead of 4, you can add quotations around the comparison value to keep it simple.

     

    ECMFilter2 =
IF (
SELECTEDVALUE('Project1)'[EffectiveDate]) < TODAY() &&
[ME Status Number] = 4 &&
[QE Status Number] = 4 &&
[MR Status Number] = 4 &&
[PC Status Number] = 4 &&
[TL Status Number] = 4,
TRUE(),
FALSE()
)

    Nothing's changed for the date conditional.  Does it still return true in all instances?

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

That would be becasue I forgot the closing parenthesis in part of the expression.  That's what I get for not testing this directly in PBI first.

 

HideProject = 
IF (
    SELECTEDVALUE(Projects[EffectiveDate]) < NOW() && 
        SELECTEDVALUE(Projects[ME]) = Complete && 
        SELECTEDVALUE(Projects[QE]) = Complete && 
        SELECTEDVALUE(Projects[MR]) = Complete && 
        SELECTEDVALUE(Projects[PC]) = Complete && 
        SELECTEDVALUE(Projects[TL]) = Complete, 
    TRUE(), 
    FALSE()
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

The formula isn't erroring out anymore, but it is not working properly. I have a project which meets all of the criteria of the formula, but is returning as False. Any suggestions?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    • Cmcmahan's avatar
      Cmcmahan
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      I may have messed up again and forgotten quotation marks around each of the Complete values.  Did it not give you some sort of warning that it didn't know what Complete was?

       

      Try this update:

      HideProject = 
IF (
    SELECTEDVALUE(Projects[EffectiveDate]) < NOW() && 
        SELECTEDVALUE(Projects[ME]) = "Complete" && 
        SELECTEDVALUE(Projects[QE]) = "Complete" && 
        SELECTEDVALUE(Projects[MR]) = "Complete" && 
        SELECTEDVALUE(Projects[PC]) = "Complete" && 
        SELECTEDVALUE(Projects[TL]) = "Complete", 
    TRUE(), 
    FALSE()
)

      If this still doesn't work, create another measure to test each condition for true.  If you can narrow down which part is evaluating to false, you can fix that and hopefully fix the measure.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I had already added the qutations. I will test each condition and let you know what I find. Thank you for your help!