topic Only Include Applicable Values when combing custom string with other measures in DAX Commands and Tips

Only Include Applicable Values when combing custom string with other measures

dbalkin777 — Mon, 25 Nov 2024 18:41:43 GMT

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.

Re: Only Include Applicable Values when combing custom string with other measures

DataInsights — Mon, 25 Nov 2024 18:58:45 GMT

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