Forum Discussion

Shalaka1's avatar
Shalaka1
Regular Visitor
3 years ago

how to substitute a filter column with another column value when firing queries

Hi ,'

I need to substitute a filter column with another column value when firing queries in power bi desktop. Could you please help me for this.

 

Thanks,

Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Shalaka1 , That need lot of context ,what is used relation etc

     

    but you can try like

    calculate([your measure], filter(Table, Table[Column] in values(Newval[Val]) ) )