How to filter is not blank using DAX from measure????

[saranp780]

I have calculated from the table into a measure like in this table and there are many blank values in fields.

Student	Score
A	11
B	12
C	11
D	10
E
F
G

All of this fields in the table are the measure. Now I would like to know how can I get a filter from this measure using DAX? (Filter is not blank) Because I want to take this value after filter to use in other ways.

Thanks, everyone for reading and sharing an opinion.

[Anonymous · Accepted solution]

Hi @saranp780,

I'd like to suggest you drag measure to visual level filter, then filter records with 'is not blank' option.

Regards,

Xiaoxin Sheng

[Greg_Deckler]

What?

Start with your source data. Include any calculations, show what you want to end up with.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490