Forum Discussion
Top006
5 years agoFrequent Visitor
Using a parameter in desktop
Hello everyone, Hope someone can assist with my parameter issue which is causing a lot of headache. I have two tables; (A) with three ID's and three products for each, and (B) which a discoun...
- 5 years ago
Top006 , You need have common table ID
measure =
var _value = selectedvalue(series[value])
return
sum(TableA [Cost]), calculate(Sum(TableB[Discount]), filter(TableB, TableB[ID] = Max(ID[ID]) && TableB[Supplied qty] =_value))Bridge Table https://youtu.be/Bkf35Roman8
amitchandak
5 years agoSuper User
Top006 , You need have common table ID
measure =
var _value = selectedvalue(series[value])
return
sum(TableA [Cost]), calculate(Sum(TableB[Discount]), filter(TableB, TableB[ID] = Max(ID[ID]) && TableB[Supplied qty] =_value))
Bridge Table https://youtu.be/Bkf35Roman8
- Top0065 years agoFrequent Visitor