If Statement question

[jloper]

Hello,

I'm trying to write the following if statement to return a specif text logic in the "Budget Action" measure.  I am currently using Switch/True and running into issues with how long it is taking to refresh and hoping there may be a more efficient way to write what I'm looking to do.  (Projects vs Gantt and PRJ vs Gantt % are measures aleady in the table)

IF

Projects vs Gantt <-100, "Write off Needed"

Projects vs Gantt % <-.1, "Write off Needed"

Projects vs Gantt <0, "Review Needed"

Projects vs GAntt % >=.1, "Potential Budget Reduction"

Else

On Track

Thanks in advance

[Fowmy · Accepted solution]

@jloper 

Can you try it this way, Also, check your data model for possible optimizations:

Measure = 
var __gantt = [Projects vs Gantt]
var __gantt_pct = [Projects vs Gantt &]
return

SWITCH( 
    TRUE(),
    __gantt_pct >= 0.1, "Potential Budget Reduction",
    __gantt <-100 || __gantt_pct <- 0.1, "Write off Needed",
    __gantt < 0, "Review Needed",
    "On Track"
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn