topic Re: Relational Operations in DAX Commands and Tips

Relational Operations

seanrpeters — Fri, 12 Jan 2024 19:49:38 GMT

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?

Re: Relational Operations

Dangar332 — Sat, 13 Jan 2024 09:24:10 GMT

hi, seanrpeters

try below measure

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

data look like below

table visual look like below

Re: Relational Operations

seanrpeters — Tue, 16 Jan 2024 20:51:16 GMT

Thank you!