Forum Discussion
Card result based on two different filters
Microsoft Employee
Hmmm then I think I know what´s wrong on my side. The problem is that in my case I must have only one Category filter to interact with both tables and by doing this, I have linked the tables by creating an index in both tables, so whenever I select a category in the filter I will have the same products list in both filters Product 1 and Product 2.
So when I try to apply your solution, it does not show the variation value, it keeps showing as 0,0%
Is there any way to apply this solution you suggested having both tables linked by a column in a way that I can calculate the variation% ?
The only other possibility that I think would be creating a cartesian join in my backend process so it will export a table with all possible combinations, but this would generate a huge ammout of data since in my products table I have more than 35k products
Thanks a lot for you advices
- v-yulgu-msft
Hi lusalva,
Unfortunately, if we keep the interactions between two slicers, the measures based on them will be affected by both slicer selections, which will bring the unexpected result.
Personally, the best choice is to remove the relationship between two tables and remove the interactions between two slicers. The aim to replicate the original table is to make sure there is no influence with each other.
Best regards,
Yuliana GuThank you