Grouping not showing ungrouped values

[jcastr02]

Hello - I have a grouping based on employee title.  (Either production or non-production).  As you see I have the field as a filter - but other items are showing up on the filter that are not showing up on the ungrouped values.  I've tried to remove the field and add it back and start on a new page as well but neither have been successful.  Any ideas>

[Anonymous · Accepted solution]

Hi @jcastr02 ，

Considering that you start with a relationship, I'm guessing that the employee table is at many end of the relationship, and by default you can't filter the table at 1 end.

You might consider:
1. Change the direction of the crossfilter to BOTH (not recommended, this reduces model performance)

2. Create a new measure to filter the visual. (Please check the pbix file)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[jcastr02]

@Fowmy  I tried to go under edit interactions but I don't even see the option to ensure it filters.  Any other thoughts?  Thanks so much.

[Fowmy]

@jcastr02 

Sorry, with limited information, it is hard suggest a solution.

[Fowmy]

@jcastr02 

Please check the interaction settings if you set it up using the Edit Inteteracton under the Format Tab