Forum Discussion
Solved
Only Include Applicable Values when combing custom string with other measures
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.
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
1 Reply
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