Filter matrix table - multiple column conditions

[babuInba]

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

[v-jingzhang · Accepted solution]

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.

[Arul]

@babuInba ,

Can you share sample data and also through some clarity on your query as well?