Dimensions as Measures for KPIs

[chrisbrown1]

I am trying to use Dimensions as Measures for KPI's (It is just strings). That way I can customize the CSS for the measures. I have a sheet that looks like the following:

 When a Program is selected the KPIs look like the following:

The issue that I have is when the Title is not specified the KPI returns NULL as expected. But I would like to output an empty string or surpress/hide the KPI for that dimension.

The dimension is: SA_ID

The measures that I am using for the KPI's are of the form:

ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST)

ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST)

ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST)

How else can I aggr the data to produce an empty string when there is not a value for that Title?

The KPIs.qvf is attached.

[rachel_delany · Accepted solution]

Try:

IF(ISNULL(ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))

[chrisbrown1]

Thank you Rachel,

There was a missing parentheses in your solution, Thanks for your help.

IF(ISNULL(ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))
,'',ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))
,'',ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))
,'',ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))