Calling a parameter field in a measure without creating a relationship

[kky1]

Hello Power BI community,

My dashboard has a slicer that dynamically sets the value of a field parameter based on the selection. I now want to create a measure in a table in order to format the selected field from this slicer in a custom format. 

I've tried a number of variations for this measure and it either formats all the rows or none of the rows when what I want is for the row which matches the slicer selection to format differently and in a dynamic way. I've read a half dozen other solutions and blogs and am feeling very stuck. I do not want to create a relationship directly from my parameter table because then it will filter my table when I only want to format it.  Additionally, I want to use this parameter to calculate and filter values on just two visuals of my dashboard rather than all the visuals on the page. 

here is the slicer and paramter table which are behaving consistenly. There is a 1:1 relationship between these. 

There are a number of variations I've tried for my measure on a different table that has no relationship created to the parameter or slicer table. This code produced no formatting.

DisplayName (caps) = 
VAR SelectedParameter = SELECTEDVALUE('Dim-variableInstitution'[Display name])
RETURN
IF('Dim - Institution'[Display name] = SelectedParameter, UNICHAR(128313) & " " & 'Dim - Institution'[Display name], 'Dim - Institution'[Display name])

This code caused all the rows to format: 

DisplayName (caps) = 
IF(
    NOT(ISBLANK(SELECTEDVALUE('parameterInstitution'[ParameterName]))),
    'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name]
)

I've tried using variables, parameters and a combination of variables and parameters. Most recently, I tried making a copy of the institution table to create connections to all my data tables, but I fear that won't work either as I don't want this parameter value to filter the table across all visuals. 

Can anyone assist? Thank you in advance for any guidance!!

@kky1 

***

In case it is helpful, here are other variations I've tried. None have worked or have a syntax errors:

DisplayName (caps) =
IF(
    NOT(ISBLANK(SELECTEDVALUE('parameterInstitution'[ParameterName]))),
    'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    NOT(
        ISBLANK(SELECTEDVALUE('parameterInstitution'[ParameterName])) 
        && SELECTEDVALUE('parameterInstitution'[ParameterName]) <> 'Dim - Institution'[Display name]
    ),
    'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    NOT(
        ISBLANK(SELECTEDVALUE('parameterInstitution'[ParameterName])) 
        && SELECTEDVALUE('parameterInstitution'[ParameterName]) = 'Dim - Institution'[Display name]
    ),
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    ISFILTERED('parameterInstitution'[ParameterName]) &&
    NOT(ISBLANK(SELECTEDVALUE('parameterInstitution'[ParameterName]))) &&
    SELECTEDVALUE('parameterInstitution'[ParameterName]) = 'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    SELECTEDVALUE('parameterInstitution'[ParameterName]) = 'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    SELECTEDVALUE('parameterInstitution'[ParameterName]) = MAX('Dim - Institution'[Display name]),
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    'Dim - Institution'[paramValue] = 'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    'Dim - Institution'[paramValue] = 'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
IF(
    'Dim - Institution'[paramValue] = 'Dim - Institution'[Display name],
    UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
    'Dim - Institution'[Display name]
)

DisplayName (caps) = 
VAR SelectedParameter = SELECTEDVALUE('parameterInstitution'[ParameterName])
RETURN
CALCULATE(
    IF(
        'Dim - Institution'[Display name] = SelectedParameter,
        UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
        'Dim - Institution'[Display name]
    ),
    CROSSFILTER('Dim - Institution'[Display name], 'parameterInstitution'[ParameterName], BOTH)
)

DisplayName (caps) = 
VAR SelectedParameter = SELECTEDVALUE('parameterInstitution'[ParameterName])
RETURN
SUMX(
    VALUES('Dim - Institution'[Display name]),
    IF(
        'Dim - Institution'[Display name] = SelectedParameter,
        UNICHAR(128313) & " " & 'Dim - Institution'[Display name],
        'Dim - Institution'[Display name]
    )
)

[Anonymous]

Hi @kky1 

You can try the following measure.

DisplayName (caps) =
IF (
    SELECTEDVALUE ( 'parameterInstitution'[ParameterName] )
        = MAX ( 'Dim - Institution'[Display name] ),
    UNICHAR ( 128313 ) & " "
        & MAX ( 'Dim - Institution'[Display name] ),
    MAX ( 'Dim - Institution'[Display name] )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.