Forum Discussion
Slice value based on disconnected table with dynamic values
It depends on what you are trying to achieve. If your disconnected table contains values which appear in a column in your fact table, and you want the slicer to choose only those values, you can do something like
Measure with filter = CALCULATE( [Base measure], TREATAS( VALUES('Disconnected table'[Column]), 'Fact table'[Column]) )
It depends on what you are trying to achieve. If your disconnected table contains values which appear in a column in your fact table, and you want the slicer to choose only those values, you can do something like
Measure with filter = CALCULATE( [Base measure], TREATAS( VALUES('Disconnected table'[Column]), 'Fact table'[Column]) )
Using TREATAS might be a better solution but keep getting the error:
Not sure if this will work, but you could try duplicating the TREATAS, one version using 'Table'[Version.Version Level 01] and one version using 'Table'[Version.Version Level 01.Key]
Just tried it...not a solution. the message stays the same. But anyway. the solution is ok, just need to make sure to set it to single select.
Thank you johnt75