Display all unique commonalities in a measure and minimum starting time in another measure

[Sellgren7]

Hello

I have worked for some time now to try to write a measure i DAX that will look through a column and display all unique values based on data in another column. I have several article numbers that can be produced in several lines depending on the final delivery unit. For this article number i want to display all possible routes that part can go.

I also want to show the minimum value of starting time for that article number in another measure.

As an example i have these columns

Article number	Starting time	Line	Delivery unit
233	2022-09-01 12:00	Flow 1	1
233	2022-09-01 12:10	Flow 1	2
233	2022-09-01 12:20	Flow 2	3
233	2022-09-01 12:30	Flow 1	4
233	2022-09-01 12:40	Flow 1	5
233	2022-09-01 12:40	Folw 2	6

In the first measure i want to show:

Article number	Possible production lines
233	Flow1, Flow 2

In the second measure i want to show:

Article number	First start time
233	2022-09-01 12:00

In the displayed table in PBI i will only have one row for each article number

Please help me out 🙂

[Anonymous · Accepted solution]

Hi

PLease try yhis

this is the result with your datas

And the 2 measures are :

Possible production lines =

        CONCATENATEX (

            CALCULATETABLE ( VALUES ( Feuil1[Line] ) ),

            Feuil1[Line],

            ", ")

Minimum date =

min(Feuil1[Starting time])

Hope it helps !

[tamerj1 · Accepted solution]

Hi @Sellgren7 

please try

Production Lines =
CONCATENATEX (
    VALUES ( 'Table'[Line] ),
    'Table'[Line],
    ", ",
    'Table'[Line], ASC
)

Start Time = 
MIN ( 'Table'[Starting Time] )

[Sellgren7]

Thanks for the quick response and the help, unfortunalely this only solved a part of my problem but i think i need to create a new post for the root problem that im unable to solve.

[Anonymous · Accepted solution]

Hi

PLease try yhis

this is the result with your datas

And the 2 measures are :

Possible production lines =

        CONCATENATEX (

            CALCULATETABLE ( VALUES ( Feuil1[Line] ) ),

            Feuil1[Line],

            ", ")

Minimum date =

min(Feuil1[Starting time])

Hope it helps !

[Sellgren7]

Thanks for the quick response and the help, unfortunalely this only solved a part of my problem but i think i need to create a new post for the root problem that im unable to solve.