To Display value in card based on slicer selection but from another table

[bilalkhokar73]

To Display value in card based on slicer selection but from another table

I Have created one slicer of table customer , if I select a customer name then i want to show that customer last sales based on selection of that slicer

Lastsalesdone=lastdate(transaction[date]) this formual is working

DisplayValue= IF(ISFILTERED(Customer[Sitename]),FIRSTNONBLANK(,1),"Please select Site name")

Now problem in display valu formual is after firstnonblank i am not getting measure Displayvlaue there so please help me hwo to do 

Display value measure is from transcation table

and sitename is from customer table   @tyemy @amitchandak @v-janeyg-msft 

[amitchandak · Accepted solution]

@bilalkhokar73, Try like

DisplayValue=
var _max = maxx(allselected(transaction) ,transaction[date])
var _customer= calculate(FIRSTNONBLANK(Table[Csutomer],1), filter(transaction,transaction[date] =_max))
return
IF(ISFILTERED(Customer[Sitename]),_customer,"Please select Site name")