To exctract all the OrderIDs from a customer by searching for a OrderID

[Imandoost]

Hi PBI Experts, 
I have a table with two columns CustomerID and OrderID. I want to get all the OrderIDs related to a customer when I search for a OrderID. How can I achieve this in PBI?
Thanks in advance!

[Cookistador]

Hello @Imandoost 

Does it solved your issue?
If it the case, can you accept my previous post as a solution

If it is not, let me know if you need more support

[Imandoost]

Hi, Thansk for the quick reply! Indeed, that is the informatrion i was looking for! However, I wonder if it's possible to get this related OrderIDs by a calculated table or something similar, instead of a measure. I like to show Order details related to these OrderIDs.

[Cookistador]

If you need, you can aslo use the measure in a matrix or a table

[Imandoost]

Thanks a lot for the explanation. I mean to show the details of the related OrderIDs rather than showing them all in one measure. Something like a dynamic table which gets updated based on the selection would be the best solution. 

[Cookistador]

Is it what you are trying to achieve?

The first table, I used to click on a value, the second to let your check each order associated to each customer

And the card is the result

If it is what you need, this is the dax I used

RelatedOrderIDs =

VAR CurrentOrderID = SELECTEDVALUE('Orders'[OrderID])

VAR CurrentCustomerID =

    CALCULATE(

        SELECTEDVALUE('Orders'[CustomerID]),

        'Orders'[OrderID] = CurrentOrderID

    )

VAR RelatedOrderIDsList =

    CALCULATE(

        CONCATENATEX(

            FILTER(

                'Orders',

                'Orders'[CustomerID] = CurrentCustomerID

            ),

            'Orders'[OrderID],

            ", "

        ),

        ALL(Orders)

    )

RETURN

    RelatedOrderIDsList

Let me know if it is not what you are trying to  achieve, and give a clear example