Categorical Slicer not showing correct summary values

[redwardspreciso]

Hello - I usually nave pretty good luck on these forums but I am stuck on this issue. 

I am trying to use a slicer to update the table callled "Roster" so that if someone is on a team or club, the roster will be updated to only include those people. I use a value like the "full_name" field in a table - the full-name is linked on the same table to a person ID which is linked to the student fact table. The program name is on a separate table and is a linked to a student ID which is in turn linked to the student fact table. Whenever I want to use the slicer to filter down to one team/club, nothnig happens to the student names. 

I've attached a link to the pbx so you can see what I'm talking about - hopefully it makes sense. 

Thank you in advance for the help. 

https://drive.google.com/file/d/10dSI1lBcgmIQK8a-11UiQkYOdsmjqubh/view?usp=sharing

[redwardspreciso]

All - thanks so much for the input. 

I was able to discover one of the issues with my model - I had a calculated measure included in the table which was messing it up. 

Thanks again!

[speedramps]

I helped you, now please can you help me with kudos.

I am a unpaid Power BI volunteer.

Please click the thumbs up and Accept as Solution for taking time to help you.
Thank you 😁

[speedramps]

I helped you, now please can you help me with kudos.

I am a unpaid Power BI volunteer.

Please click the thumbs up and Accept as Solution for taking time to help you.
Thank you 😁

[speedramps]

I am an unpaid power Bi volunteer. Please click solved to accept the solution so we get kudos. If your poblem has expanded or changed the set thos one to solved and raise a new ticket, because this question seems to have been answered ok. Many thanks.

[v-yalanwu-msft · Accepted solution]

Hi, @redwardspreciso ;

You could try it.

count = 
CALCULATE(COUNTROWS('student fact'),FILTER('student fact',[person ID] in VALUES('example programs'[Person ID])))

The final output is shown below:

As visual 1 you could create a flag measure.

flag = IF(MAX('student fact'[person ID]) in VALUES('example programs'[Person ID]) ,1,0)

Then apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[redwardspreciso]

Thanks all for the advice. I still seem to be having trouble. The fix from @speedramps helped with my simplified model but it didn't work with my actual model that is bigger and more complex. I'm not sure how to replicate the fix from the simplified model in the bigger model. 

I'm going to see if I can do a workaround with using a measure. I'll keep after it. 

Thanks again. 

[speedramps]

Hi again red

If you use badly formatted source data then it produces bad reports.

Use Power Query to format source data into a star schema with dim and fact tables for best results.

[speedramps]

Consider changing your datamodel to ...

Students:-

• Person ID
• first name
• last name

Clubs:

• Club name
• Person ID

The create a 1:M relation from Clubs[Person ID] to Students[Person ID]

Then add Club name to the Slicer and the Stidnets to a matric visual.
When you select a club then only memebrs of that club will be displayed, 

 We are unpaid volunteers so please click the thumbs up if you like this solution and then the solved button if it fixes your problem to leave kudos.

[HotChilli]

Example Programs is not going to filter anything due to it's position in the model and relationship direction.

For a very quick fix, you can make the relationship go both ways but maybe a rethink on the model is required because that may cause more problems.