topic Re: Display all unique commonalities in a measure and minimum starting time in another measure in DAX Commands and Tips

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

Sellgren7 — Thu, 06 Oct 2022 15:31:47 GMT

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 🙂

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

Anonymous — Thu, 06 Oct 2022 16:46:34 GMT

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 !

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

tamerj1 — Thu, 06 Oct 2022 16:58:42 GMT

Hi Sellgren7

please try

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

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

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

Sellgren7 — Fri, 07 Oct 2022 09:49:51 GMT

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.

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

Sellgren7 — Fri, 07 Oct 2022 09:50:09 GMT

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.