topic Re: How to get a column from the table that is filtered by another column? in DAX Commands and Tips

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

Anonymous — Thu, 29 Sep 2022 10:09:26 GMT

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.

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

johnt75 — Thu, 29 Sep 2022 10:50:53 GMT

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

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

Anonymous — Thu, 29 Sep 2022 11:27:48 GMT

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

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

mbamber — Thu, 29 Sep 2022 11:58:49 GMT

use DISTINCT instead of VALUES

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

tamerj1 — Thu, 29 Sep 2022 17:45:18 GMT

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] )

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

Anonymous — Fri, 30 Sep 2022 07:14:03 GMT

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

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