Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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")
@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")
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |