When filter is selected show value in column but alias other column values but still display values

[Shawnee]

Hi All,

I have probably done 100 google searches for this query but have had no luck with it. What I want to achieve is when a user selects a value in the slicer, for that value to display in a table but all other values be replaced by an alias.

See example below:

Any help would be greatly appreciated!

Kind regards,

Shawnee

[Greg_Deckler]

@Shawnee Would probably need to understand your data model a little better. Is there a list of these aliases? You would need to write a measure for this like:

Measure =
  VAR __Value = SELECTEDVALUE('Slicer'[Column])
RETURN
  IF(MAX('Table'[Column])=__Value,__Value, <alias lookup goes here>)

[Shawnee]

Thank you for your response, unfortunately it didn't solve my issue.

In response to your question, I have a column with a list of aliases for the selected value and a column with the list of the slicer selections in the same table. I need to be able to select from the slicer and display the selection but replace all other values with the corresponding alias column value. Hope this makes sense.

Thanks again!