Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
KingEvilBadger
New Member

Roles Filter not working: Doesnt find values in table

I feel like Im losing my mind here.

I have a table with several names

 

I want to filter the table based on the role

 

E.g. If the Role is Lindrie Omoda, it must filter the table to Lindrie (Omoda)

 

 

KingEvilBadger_0-1685971755125.png

 

 

Here is my Dax code in the role area:

KingEvilBadger_1-1685971790372.png

 

Code is pretty much the same in each of the roles, just names that change

It works for almost every other name, except 2 or three in the table

 

Ive checked for hidden spaces, cannot get it to work

 

Here is what is shows when I view as Stellenbosch Omoda:

KingEvilBadger_2-1685971875610.png

 

 

What am I doing wrong?

1 REPLY 1
NaveenGandhi
Super User
Super User

Hello @KingEvilBadger 

Is there any active relationship between Group1DPDashboarda and Group1Stock. If yes check the filtering table if it contains information for "Lindrie (Omoda)".

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors