- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filter out all rows with at least one column >=3
Hi everyone,
I am creating a DAX measure for a matrix visual. I have no idea how to write the DAX or any other way. The requirement is that the matrix has only the rows with at least one column has data larger than 3. For example, if a row is (0, 0, 0, 1, 2, 3, 0), then this row should be left. If a row is (1,1,1,2,1,2,1), then this row should be filtered out.
The DAX I use is this:
Blue arrows are showing which rows I want to have. The matrix without filtering is this:
Thank you in advance for your help!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , Actually need to know what is on the row. Based on that we need to take max of that value for a week day and filter that row.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not enough data... but one thing is certain: at some point in the code you must use the ALLSELECTED function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , Actually need to know what is on the row. Based on that we need to take max of that value for a week day and filter that row.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-06-2024 12:21 PM | |||
08-22-2024 09:13 AM | |||
04-09-2023 11:13 PM | |||
09-14-2023 02:21 PM | |||
03-12-2024 07:51 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |