DISTINCT COUNTX for an EXPRESSION?

[ADRICHECKIN]

Hi team,

Can I get through an expresion de unique values after concatenate the 4 first columns ( Reservation, date, train, wagon ) ? 

Now I'm aplying a DISTINCOUNT to COMBINEVALUES ( columns )

RESERVATION	DATE	TRAIN	WAGON	PAX		COMBINEVALUES
1-101	14/11/2020	A	1	1		1-10144149A1
1-101	14/11/2020	A	1	2		1-10144149A1
1-101	15/11/2020	A	1	1		1-10144150A1
1-101	15/11/2020	A	1	2		1-10144150A1
1-102	14/11/2020	A	1	1		1-10244149A1
1-102	14/11/2020	A	1	2		1-10244149A1
1-102	14/11/2020	A	1	3		1-10244149A1
1-103	14/11/2020	A	1	1		1-10344149A1
1-103	14/11/2020	B	2	1		1-10344149B2
1-103	14/11/2020	B	3	1		1-10344149B3

Thank you,

[CNENFRNL]

Hi, @ADRICHECKIN , you can easily get the job done in Powe Query by adding a custom column

[RESERVATION] & Text.From(Number.From(Date.From([DATE],"fr"))) & [TRAIN] & Text.From([WAGON])

[AlB · Accepted solution]

Hi @ADRICHECKIN 

Try this measure in card visual

Measure =
COUNTROWS (
    SUMMARIZE (
        Table1,
        Table1[RESERVATION],
        Table1[DATE],
        Table1[TRAIN],
        Table1[WAGON]
    )
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers