Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I would like to have the following filtered in a matrix.
All products without sales, as well as all products that have received a comment.
The comment is a column from the database and a measure witch "last purchase" . I implemented both as values in the table.
If nobody has ever bought this product, there is a blank in the respective line of the product under "last purchase".
How can I set this in the filters so that all products that have a comment are displayed as well as products that have never been bought.
This is what I want with the 2 filters, when i use them in the matrix:
First show all products with blank "last purchase", then show additionally show all products with an comment that contain Yes.
What I actually got, when I use both filters. Only products which contains both (last purchase blank and Comment Yes):
Hope you can help me here! Thanks.
Hi,
Your Question is not completely clear.
Actually it seems that you only need the filter "YES" on Comment. Is it right?
If not please clear what you mean by an example.
Thanks
Hi,
I have stated that I would like to have both filters activated in the matrix, with no loss. Both Filter, the one with comment "Yes" and blank products should be displayed.
Instead, when I display both, I only get the output when both are considered together. What I don't want.
The two filters should be activated independently of each other and should not influence each other.
Hope this is clear enough.