cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Resident Rockstar

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.

Resident Rockstar

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.