Return values related to selected ones

[Anonymous]

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

[sturlaws · Accepted solution]

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 (
    ADDCOLUMNS (
        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.