Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
azaterol
Helper V
Helper V

2 filters activate in a matrix

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.

azaterol_0-1678454612883.png

 

What I actually got, when I use both filters. Only products which contains both (last purchase blank and Comment Yes):

azaterol_1-1678454871621.png

 

Hope you can help me here! Thanks.

 

 

 

2 REPLIES 2
MohammadLoran25
Super User
Super User

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

@MohammadLoran25 

 

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.