Forum Discussion
Filtering a Matrix Based on Values in one Column + slicer
Greetings everyone,
We are having trouble applying a filter to a matrix that has multiple rows and columns. We want to have a slicer with which we can cut down the matrix to only show rows for which values in a certain column in our matrix are negative. See the picture here: we want to be able to filter to only shows rows for which the February **bleep**.Delta < 0. Thanks for your help!
Hi basicquestions ,
I have created a simple sample, please refer to it to see if it helps you.
Please have a try.
Create a measure.
i = VAR _2 = CALCULATE ( MAX ( 'Table'[value] ), ALLSELECTED ( 'Table'[subject] ) ) RETURN IF ( MAX ( 'Table'[value] ) = _2 && MAX ( 'Table'[value] ) <= 0, MAX ( 'Table'[value] ), BLANK () )If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi basicquestions ,
I have created a simple sample, please refer to it to see if it helps you.
Please have a try.
Create a measure.
i = VAR _2 = CALCULATE ( MAX ( 'Table'[value] ), ALLSELECTED ( 'Table'[subject] ) ) RETURN IF ( MAX ( 'Table'[value] ) = _2 && MAX ( 'Table'[value] ) <= 0, MAX ( 'Table'[value] ), BLANK () )If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.