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 ...
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
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