Forum Discussion

Top006's avatar
Top006
Frequent Visitor
5 years ago
Solved

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...
  • amitchandak's avatar
    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