Forum Discussion

Emiel99's avatar
Emiel99
Frequent Visitor
2 years ago
Solved

Disctinct values in a Conactenatex with multiple values.

Hi All, I'm looking for a solution to a problem I'm having.  I have two tabels:  (Vendor) Stock Orders 2 FactKey             Supplier              SupplierCountry FAC-001 Supplier1 NL ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Emiel99 I *think*

     SupplierCountry = CONCATENATEX (
    DISTINCT(
      SELECTCOLUMNS(
        FILTER (
            ALL ( '(Vendors) Stock Orders 2' ),
            '(Vendors) Stock Orders 2'[FactKey] = 'Posted Sales Invoice Subform (Q-MC)'[PostedSalesKey]
        ),
        "__SupplierCountry", [SupplierCountry]
      )
    ),
    [__SupplierCountry],
        ", "
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

Emiel99 I *think*

 SupplierCountry = CONCATENATEX (
    DISTINCT(
      SELECTCOLUMNS(
        FILTER (
            ALL ( '(Vendors) Stock Orders 2' ),
            '(Vendors) Stock Orders 2'[FactKey] = 'Posted Sales Invoice Subform (Q-MC)'[PostedSalesKey]
        ),
        "__SupplierCountry", [SupplierCountry]
      )
    ),
    [__SupplierCountry],
        ", "
)
  • Emiel99's avatar
    Emiel99
    Frequent Visitor
    2 years ago

    Indeed this works, thanks!!