Fetching one value from calculated column

[AlanP514]

Hai All, I Am new Dax, Please help me

Is Graduating = if ('Demo Log'[Is Active ]="Yes" && 'Demo'[Initiative Type] = "Sprint", "YES","NO")

From the above equation denoting To "YES" and "NO"  values.

From the above equation, I want to create a calculated column only with a "YES" Value.
Ie. From  this specific Calculation, I only want to fetch "YES" Values

[lbendlin]

Do you want to change the formula ?  In that case you can omit the ,"No" part, it is optional

Or do you want to filter your table for rows that evaluate to "Yes" ?

[AlanP514]

only yes

[lbendlin · Accepted solution]

You would use a filter for that. You can choose visual level, page level, report level filters or you can create a calculated table.