Forum Discussion
bidirectional filtering not working
I'm assuming you have a situation where you have 3 games with sales (A, C, and E) and 2 with no sales (B and D) but if you add the Dim_Games table Game Name to the filter panel, you are seeing all games like in the first when you only want it to show A,C, and E like in the second image.
If this is the goal where you can only see those with sales in the filter panel (plus blank for some reason), I used a helper table.
The helper table is made using this dax code. It basically filters the Dim_Games table and only displays the Game_Name with sales greater than 0 (sales = sum(fact_table[sales]) and the Game ID.
This is so we can create a 1:* (1 to many) relationship from this new table to the fact table using the Game ID column. I also tested that it would add new game names if B suddenly had sales, it also showed up in the helper table during refresh.
Im hoping this helps.
I'm assuming you have a situation where you have 3 games with sales (A, C, and E) and 2 with no sales (B and D) but if you add the Dim_Games table Game Name to the filter panel, you are seeing all games like in the first when you only want it to show A,C, and E like in the second image.
If this is the goal where you can only see those with sales in the filter panel (plus blank for some reason), I used a helper table.
The helper table is made using this dax code. It basically filters the Dim_Games table and only displays the Game_Name with sales greater than 0 (sales = sum(fact_table[sales]) and the Game ID.
This is so we can create a 1:* (1 to many) relationship from this new table to the fact table using the Game ID column. I also tested that it would add new game names if B suddenly had sales, it also showed up in the helper table during refresh.
Im hoping this helps.
Thanks, this is exactly what I need. Not sure how fast it will be with millions of rows in the fact table but I'll test it.
