cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Return values related to selected ones

Hi all,

I have this datasource:

 key Item Number Project ID Project Due Date 0 948 RCN-026 202352 1 937 RCN-026 202352 2 801 RCN-026 202352 3 302 BJS-682 202238 4 143 BJS-682 202238 5 989 BJS-682 202238 6 791 PPT-112 202352 7 702 PPT-112 202352 8 476 PPT-112 202352 9 446 PPT-112 202352

I have a slicer to select some project IDs

I want to have two text boxes: one to display all the project IDs selected, one to dislpay the related due date FOR EACH project.

I use this formula to display the projects:

``selectedProjects = CONCATENATEX(VALUES(Table[Project ID]), [Project ID], UNICHAR(10))``

And this one to display the due dates:

``dueDate = CONCATENATEX(VALUES(Table[Project Due Date]), [Project Due Date], UNICHAR(10))``

I obtain this:

But expected result is this:

It has to be dynamic when I select other projects...

Anyone can help me on this?

Thanks a lot

arthurld

1 ACCEPTED SOLUTION
Super User

Hi, @Anonymous,

the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.

Could you try to write your measure like this instead:

``````dueDate =
CONCATENATEX (
VALUES ( 'Table'[Project ID] ),
"tmp", CALCULATE ( MIN ( 'Table'[project due date] ) )
),
[tmp],
UNICHAR ( 10 )
)``````

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Super User

Hi, @Anonymous,

the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.

Could you try to write your measure like this instead:

``````dueDate =
CONCATENATEX (
VALUES ( 'Table'[Project ID] ),
"tmp", CALCULATE ( MIN ( 'Table'[project due date] ) )
),
[tmp],
UNICHAR ( 10 )
)``````

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Announcements