Forum Discussion

KubenM's avatar
KubenM
Advocate II
3 years ago

How can multiple values in the same cell be read separately by Power Bi filter?

Hello

I have a filter setup for Increment that uses a Fact Table that has the following individual values defined:

Y23PI1

Y23PI2

Y23PI3

Y23PI4

 

My dimension table reflects that some rows have mulitple Increments in the same cell for example: Y23PI1, Y23PI2 or Y23PI2, Y23PI3, Y24PI4

As my filter only references single Increments, when I filter on Y23PI1 or Y23PI2, Power Bi returns zero as it can't find the single Increments. 

Please assist if possible.

Kind Regards

Show and Tell

2 Replies

    • KubenM's avatar
      KubenM
      Advocate II
      3 years ago

      Hello

      Thank you for taking the time to assist me in this regard.

      Another person in this community assisted with a solution in another post that was logged by someone else. So I am happy with the solution he provided. Once again. Thank you.