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

[v-vpabbu]

Hi @Imandoost,

Thanks @Cookistador for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @Imandoost,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[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