Only Include Applicable Values when combing custom string with other measures

[dbalkin777]

Greetings,

I am looking to create a longish DAX measure that combines some custom text with measures already written. How would I filter out those entries that aren't applicable, but are showing up on my table due to the custom string portion of my measure:

Thank you.

[DataInsights · Accepted solution]

@dbalkin777,

Add logic that returns a value only if the measure is not blank:

Formatted All Outputs =
VAR vMeasureValue = [All Research Objective Outputs]
VAR vResult =
    IF (
        NOT ISBLANK ( vMeasureValue ),
        "Research Objective:" & UNICHAR ( 10 ) & vMeasureValue
    )
RETURN
    vResult