How to Slice data that contains several entries from the slicer value

[andicornejo12]

Hello,

I am stuck on how to solve this. Basically I have a dimensions table where I have a code and the description:

On my fact table I have the records that can contain several codes from my dimensions table:

How can I combine them or how can I use the Handling Code to slice the data in the fact table?

Hope I made my=self clear enough. Thanks for your help!

[v-yangliu-msft · Accepted solution]

Hi  @andicornejo12 ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTEDVALUE('Table'[Hide Code])
return
IF(
CONTAINSSTRING(
    MAX('dimensions table'[Handling Code List]),_select)=TRUE(),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

[andicornejo12]

Hi @v-yangliu-msft It doesnt work though if I pick more than one value in the slicer. Is it because of the format? would having spaces help? Thanks so much!!

[andicornejo12]

Thanks a lot! works perfect 🙂

[YukiK]

You don't need to concatenate those values into a fact table. Just use the code column in a slicer visual, making sure there is a relationship between the dimension and fact table. That slicer visual would have the list of values you can slice and dice