Forum Discussion

seanrpeters's avatar
seanrpeters
Frequent Visitor
2 years ago
Solved

Relational Operations

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's avatar
    Dangar332
    2 years ago

    hi, seanrpeters 

    try below measure

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

     

    data look like below

     

    table visual look like below

     


     

2 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, seanrpeters 

    try below measure

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

     

    data look like below

     

    table visual look like below