Forum Discussion
Filter matrix table - multiple column conditions
Hi Experts,
I would like to filter only non blanks values from matrix table, given below snapshot FYI ( Filter only non blank rows based on overall score value)
OVerall score is a measure, i tried below query but im getting error
filter(table,not(isblank(overallscore)))
error = expression refer to multiple column, multiple column cannot be converted as scalar value
| Matrix table - Current | |||
| Name | Test | TEst2 | Overall score |
| User1 | 50 | 50 | 100 |
| User2 | 50 | 25 | 75 |
| User3 | 40 | ||
| User4 | 35 | ||
| Matrix table - expected | |||
| Name | Test | TEst2 | Overall score |
| User1 | 50 | 50 | 100 |
| User3 | 50 | 40 | 75 |
Hi babuInba
Are "Test", "Test2" and "Overall score" measures? If they are measures, displaying them in a table visual instead of a matrix will make it easier. In the Filter pane, you can expand Overall Score field and select is not blank option to filter only non blank rows.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
Hi babuInba
Are "Test", "Test2" and "Overall score" measures? If they are measures, displaying them in a table visual instead of a matrix will make it easier. In the Filter pane, you can expand Overall Score field and select is not blank option to filter only non blank rows.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
