Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |