Eventstream - Filter

[tan_thiamhuat]

Here, I filter the No_Bikes equal to zero, but why the EmptyRacks show its column to be non-zero?

[V-yubandi-msft · Accepted solution]

Hi @tan_thiamhuat ,

Thank you for reaching out to the Fabric Community.

@suparnababu8 , has provided some helpful insights, but it seems the issue still persists.@bao_phan  also shared their experience, which might be relevant in this case. Please review @bao_phan  response, as it could offer additional guidance.

We appreciate your valuable contributions to the community and thank you for continuing the discussion.

Regards,

Yugandhar.

[V-yubandi-msft · Accepted solution]

Hi @tan_thiamhuat ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank You.

[V-yubandi-msft · Accepted solution]

Hi @tan_thiamhuat ,

Thank you for reaching out to the Fabric Community.

@suparnababu8 , has provided some helpful insights, but it seems the issue still persists.@bao_phan  also shared their experience, which might be relevant in this case. Please review @bao_phan  response, as it could offer additional guidance.

We appreciate your valuable contributions to the community and thank you for continuing the discussion.

Regards,

Yugandhar.

[bao_phan]

As my experience with EventStream, you should check the type of the column to make sure it is int (to do comparison with 0). Should refresh or re-run the EventStream again and wait for their result. Please update the situation so that I can help you more.

[suparnababu8]

Hi @tan_thiamhuat 

It's becuase of you applied filer condition on No_Bikes equal to zero, it affecting the rows No_Bikes = 0 are removed, but other columns (as mentioned by you EmpyRacks) retain the original values. It doesn;t affect other columns presented in dataset.

Thank you for asking this questions

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[tan_thiamhuat]

now it shows this:

[suparnababu8]

Hi @tan_thiamhuat 

Oh Wonder🙂. I think there is lag to update the records. When you applied No_bikes=0, it should filter only that column. Now it's showing No_bikes column has 0 but empy racjs doesn't. 

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[tan_thiamhuat]

No_bikes column has 0 is inside the EmptyRacks

[suparnababu8]

Hi @tan_thiamhuat 

Agree. But for few of the rows showing values.I'm not sure why it is shwoing.

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[tan_thiamhuat]

hur? I have thought that Filter works such that EmptyRack should show No_Bikes = 0, isn't that it should?