Forum Discussion
Filter not showing what expected
Hello all. I have two tables and one filter. The first table shows information about product value for every year and the second table shows countries that exported selected products from the first table. The filter(shows greater than values, in this case, it is showing values greater than 10) applies only to the first table. My current problem is I set the filter to show me values greater than 10 and it is working however if you noticed in the 1st table for the product "240220" showing 77.4, while the second 100.8. so the second values are correct. As I understood in the first table total values are based on values greater than 10. How can I make that filter that must apply to the total? in this case for the product "240220" should show me 100.8.
8 Replies
PaulDBrownCommunity Champion
Anonymous
How is you model set up and what fields are used in each table (from dimension tables?)
- AllisonKennedy
Anonymous we need a lot more information please to be able to help you out.
Your visualizations have more than just one field in them - what other columns have you used in the visualizations? What measures and can you please paste the exact DAX you're trying for these measures?
Finally and VERY IMPORTANT - what does the raw data model look like - screenshot of Model view will help if we can see all/most columns of each table and we'll need to know what field relates the two tables.
- AllisonKennedyYou may need to create a measure for the $ calculation that uses the ALL() function to calculate the total for all prices.
Total = CALCULATE(SUM(column), ALL(filteredvalues)) 
v-xicaiCommunity Support
Hi Anonymous ,
To get matched values when make filters, you may make sure the Cross filter direction of the two tables is Both instead of Single, which will take the two tables treated as a single table.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AllisonKennedyAmy ( v-xicai ) is right - a cross filter direction of both can help with filtering and treating two tables as one, but I do not recommend this solution for a 1 to many relationship.
Please Anonymous can you share more details about your data model relationships so we can target our solutions, ideas and advice better?
- v-xicai
Hi Anonymous ,
Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
