Forum Discussion

sarikei's avatar
sarikei
Helper I
3 years ago

Display selected value from other visual

Hi

 

I have a Slicer to display the Purchase Date from table PurchaseOrder.

I have the other Slicer display the Order Date from table SalesOrder.

The relationship is defined for this 2 table. So when I click and select the Purchase Date from the Slicer, the corresponding Order Date will be selected/displayed on the other Slicer.

Now I want to create the Measure to capture and display the Order Date using the following:

 

Order Date = selectedvalue(SalesOrder[OrderDate])

 

I can’t display the value of this measure on any visual i.e. Card.

But I can use the following display the Purchase Date on Card:

 

Order Date = selectedvalue(PurchaseOrder[PurchaseDate])

 

Why? How can I display the selected value from other visual?

 

Thank you.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    sarikei , One of the measure should work

     

    Order Date = selectedvalue(SalesOrder[OrderDate])

     

    or

     

    Order Date = maxx(allselected(SalesOrder), SalesOrder[OrderDate])

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.