cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
quipmaster
Helper II
Helper II

Slicer not interacting with multiple tables

Hello Power BI experts,

 

In today's call for help, my slicers are not interacting with graphs from multiple tables.

 

The three bar charts come from tables: Different, Help, Learn. 

 

The TAP slicer comes from the Able Table.

 

quipmaster_0-1664835663788.png

 

This is my Relationship model. I get a warning of Many to Many relationship is I try to establish a relationship between Able and Help or Different or Learn. 

 

Able, Help, Learn, and Different are dimension tables connected to the Fact Table by LEA ID. I thought that connecting the Dim tables to the Fact table would make the slicer work. 

 

Help Percent =
DIVIDE(
COUNT(
'Help'[Category]),
CALCULATE(COUNT('Help'[Category]),
ALL()
))
 
I've tried CrossFilter to no avail. 

 

If you could be me a gentle nudge in the DAX or relationship, that would be much appreciated. 

 

quipmaster_1-1664835764872.png

 

Please let me know if you have any questions. 

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

Hi @quipmaster,

 

I can see that the joins between Able and Help / Learn / Different have a bidirectional cross filter. Since you are using the same LEA ID column to join all the tables, it might be affecting the data that you are seeing. Why don't you try this with single direction joins!

View solution in original post

2 REPLIES 2
quipmaster
Helper II
Helper II

I think there was one more issue that resolved my dilemma. 

 

LEA ID is double-counted for respondents. I decided to have the model tied to participant_ID. Voila the interactions worked!

 

Thank you for your guidance.

Shaurya
Memorable Member
Memorable Member

Hi @quipmaster,

 

I can see that the joins between Able and Help / Learn / Different have a bidirectional cross filter. Since you are using the same LEA ID column to join all the tables, it might be affecting the data that you are seeing. Why don't you try this with single direction joins!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors