Filter not showing what expected

[Anonymous]

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.

[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

[v-xicai]

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.

[AllisonKennedy]

Amy ( @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?

[AllisonKennedy]

You 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))

[Anonymous]

Thanks for your reply however it did not work for me

[PaulDBrown]

@Anonymous 

How is you model set up and what fields are used in each table (from dimension tables?) 

[Anonymous]

I used Import values for both, and product ID for the first and country for the second

[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.