How to get a column from the table that is filtered by another column?

[Anonymous]

Now, my calculated table looks like this:

FRU Status intermediate table = 
ADDCOLUMNS(
    VALUES('All Project v2'[Project Name]),
        "Flag", [stat chart]
    )

VALUES() here returns all values of the [Project Name] column.

I need it to return values based on the column 'All Project v2'[Dashboard Created] = "Yes", so if the 'project' has 'dashboard' - return the column.

[johnt75 · Accepted solution]

FRU Status intermediate table =
ADDCOLUMNS (
    CALCULATETABLE (
        VALUES ( 'All Project v2'[Project Name] ),
        'All Project v2'[Dashboard Created] = "Yes"
    ),
    "Flag", [stat chart]
)

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

FRU Status intermediate table =
SUMMARIZE (
    FILTER ( 'All Project v2', 'All Project v2'[Dashboard Created] = "Yes" ),
    'All Project v2'[Project Name],
    "Flag", [stat chart]
)

[Anonymous]

I tried it, and it works fine, but it doesn't solve the further problem...

Well, technically, you guys gave me the solution, so...

[johnt75 · Accepted solution]

FRU Status intermediate table =
ADDCOLUMNS (
    CALCULATETABLE (
        VALUES ( 'All Project v2'[Project Name] ),
        'All Project v2'[Dashboard Created] = "Yes"
    ),
    "Flag", [stat chart]
)

[Anonymous]

It does work, yes. But a new problem arose: I can't create a relationship with the table I am pulling columns from due to circular dependency.

With Values() it doesn't have CD

[mbamber]

use DISTINCT instead of VALUES