topic Re: Slicer not interacting with multiple tables in DAX Commands and Tips

Slicer not interacting with multiple tables

Anonymous — Mon, 03 Oct 2022 22:27:13 GMT

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.

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.

Please let me know if you have any questions.

Re: Slicer not interacting with multiple tables

Shaurya — Tue, 04 Oct 2022 00:31:34 GMT

Hi Anonymous,

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!

Re: Slicer not interacting with multiple tables

Anonymous — Sat, 08 Oct 2022 16:51:42 GMT

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.