Measure that only calculates when logical condition is met and otherwise returns blank

[lukeLiu]

Greetings,

I have a very simple question, but have had difficulty framing the search terms. Any guidance would be appreciated!

In creating a measure, I have a simple logical test on the value of a field - e.g. [Status]. I'd like to write it so that if [Status] does not equal "Approved" return blank, but otherwise start a more tedious calculation with multiple variables. Is there a way to do this to make the measure more efficient?

Thank you.

[ajohnso2 · Accepted solution]

New Measure =

VAR _Check = MAX('Table'[Status])

RETURN

SWITCH(

TRUE(),

_Check <> "Approved", BLANK(),

<Do Something Else>

)

[lukeLiu]

Awesome, thanks!