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 = FIL...
  • 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

     


     

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

 


 

  • seanrpeters's avatar
    seanrpeters
    Frequent Visitor
    2 years ago

    Thank you!