Forum Discussion

ADRICHECKIN's avatar
ADRICHECKIN
Frequent Visitor
5 years ago
Solved

DISTINCT COUNTX for an EXPRESSION?

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 )

 

RESERVATIONDATETRAINWAGONPAX COMBINEVALUES
1-10114/11/2020A11 1-10144149A1
1-10114/11/2020A12 1-10144149A1
1-10115/11/2020A11 1-10144150A1
1-10115/11/2020A12 1-10144150A1
1-10214/11/2020A11 1-10244149A1
1-10214/11/2020A12 1-10244149A1
1-10214/11/2020A13 1-10244149A1
1-10314/11/2020A11 1-10344149A1
1-10314/11/2020B21 1-10344149B2
1-10314/11/2020B31 1-10344149B3

 

Thank you,

Need Help
  • AlB's avatar
    AlB
    5 years ago

    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 

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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 

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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])