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.

``````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.

``````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

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

#### Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors