Relational Operations

[seanrpeters]

Hello,

I want to use the comparrison opperator == in order to filter out data in a measure. The values stored are Y or N, I want to include only the Y values in my measure like so:

NewHire = FILTER ( 'table', [YN] =='Y' )

This is obviously not the right way to do this, but how would I? 

[Dangar332 · Accepted solution]

hi, @seanrpeters 

try below measure

Measure = 
 FILTER( VALUES('Table'[Column1]),'Table'[Column1]="y")

data look like below

table visual look like below

[seanrpeters]

Thank you!