Forum Discussion
Solved
Fetching one value from calculated column
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
You would use a filter for that. You can choose visual level, page level, report level filters or you can create a calculated table.
3 Replies
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" ?
