Filter If Formula

[Craigc3814]

I have this formula as a column so that I can slice data using it. I need the formula to only calculate when the Curr Phase column = Planning. I know it is simple but I cannot get it

PlanningChg2 = IF(OR(MSD_ALL_CAP_TRANS_BAC[Dollar Diff]>500000, MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]>.5),"Yes",IF(OR(MSD_ALL_CAP_TRANS_BAC[Dollar Diff]<-500000,MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]<-.5),"Yes","No"))

[Daryl-Lynch-Bzy]

@Craigc3814  - would this work?

PlanningChg2 = 
IF ( MSD_ALL_CAP_TRANS_BAC[Curr Phase] <> "Planning",
"No",
IF (
  OR ( MSD_ALL_CAP_TRANS_BAC[Dollar Diff]>500000,
       MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]>.5),
 "Yes",
 IF (
    OR( MSD_ALL_CAP_TRANS_BAC[Dollar Diff]<-500000,
        MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]<-.5),
    "Yes",
   "No")
)
)

[Craigc3814]

When the Curr Phase is Planning I need it to do the rest of the calc, when it is not planning I need it to say "No"

[Daryl-Lynch-Bzy]

sorry replace = "Planning" with <> "Planning".

[Craigc3814]

Thank you that worked but did not solve the overall problem I am running into, I was unaware you could not use measures as a slicer and it is wreaking havoc on my day

[Daryl-Lynch-Bzy]

You are using this to create a Calculated Column.  The Column can be used in the Slicer?

[Craigc3814]

The calculated column was my attempt at a work around. I have a ton of page level filters that I would need to incorporate for it to work right.