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?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

All of the data sourced for the report is from a SharePoint list. In the SharePoint list each role has a dropdown menu to select their status. (Not Started, In Process, etc..) Would that be causing these issues?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Got it working. Used the measure I created previously that assigned a number to each status (1=Does Not Apply, 2=Not Started, etc...) then used value instead of selectedvalue.

ECMFilter2 =
IF (
VALUE('Project1)'[EffectiveDate]) < TODAY() &&
VALUE('Project1)'[ME Status Number]) = 4 &&
VALUE('Project1)'[QE Status Number]) = 4 &&
VALUE('Project1)'[MR Status Number]) = 4 &&
VALUE('Project1)'[PC Status Number]) = 4 &&
VALUE('Project1)'[TL Status Number]) = 4,
TRUE(),
FALSE()
)
  • Cmcmahan's avatar
    Cmcmahan
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Well, I'm not sure why it's working as well as it is, but if it gives the correct result, I'm not going to argue.  Congrats on figuring it out!

  • Cmcmahan's avatar
    Cmcmahan
    Icon for Resident Rockstar rankResident Rockstar
    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I switched the effective date to value as well instead of selectedvalue. Everything is functioning exactly as I want it to. I've been testing different scenarios to make sure it won't fail and it seems to be working correctly. 

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    Please kindly mark the most helpful solution as answer to finish the thread and help others to find it more quickly. thanks!