Forum Discussion
Filter Dax rows with list
Felipepbiplis As you mentioned there is no relation between table , A Nice way to solve this these using relationships with bridge table introduced between them and use that to get best out of the Power BI Modelling
However Alternately you can create measure to pass one selected value from one visual to other and use that to apply filters on the other in Filters pane or play bit with visual interactions
Here is DAX which can help you
1. Selected Value = SELECTEDVALUE(TAble1[Profiles],"No filter")
2. If filtered =Var Filteredvalue =If(CONTAINSSTRING([Selected Value],SELECTEDVALUE(Table2[Ruler]) ),1,0)ReturnFilteredvalue
Result will be something like below , Note that if i choose rick the IFfiltered measure becomes 1 for only those Rows in Table 2 , The you can use If filtered = 1 in your filter pane visual if you like
But I believe changing your model can you give much better and clean results !-------------------------------------------------------------------------------------------------------------------------------
Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?
Resolver IVFelipepbiplis As you mentioned there is no relation between table , A Nice way to solve this these using relationships with bridge table introduced between them and use that to get best out of the Power BI Modelling
However Alternately you can create measure to pass one selected value from one visual to other and use that to apply filters on the other in Filters pane or play bit with visual interactions
Here is DAX which can help you
1. Selected Value = SELECTEDVALUE(TAble1[Profiles],"No filter")
2. If filtered =
Result will be something like below , Note that if i choose rick the IFfiltered measure becomes 1 for only those Rows in Table 2 , The you can use If filtered = 1 in your filter pane visual if you like
But I believe changing your model can you give much better and clean results !
-------------------------------------------------------------------------------------------------------------------------------
Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?