Forum Discussion
filter table based on dynamic table
Hi, Im looking for a way to filter table (TargetTable) based on the data (FilterTable) that I can modify. So when I update outside of Power BI and then refresh it in PowerBi then the TargetTable is ...
You cannot have dynamic tables outside of measures. Do you mean "as dynamic as the dataset refresh" ?
By the way you can simplify your formula
TargetTable = SUMMARIZECOLUMNS(MainTable[index],
filter(MainTable,MainTable[GroupSum]=6&&
MainTable[group 1] IN {1,2,3} &&
MainTable[group 2] IN {0,1} &&
MainTable[group 3] IN {0,1,2}))
lbendlin thanks for the suggested simplification.
Yes, the numbers to be in the filter are based on the supposed table that will be updated every now and then. It will also be loaded, so everytime I udpate it, the resulting formula I expected to be updated as well.
I was able to use the relatedtable, but it only provide correct filter for the column that is directly has the relationship. Is there any solution outside of measure? Can you also share the possible measure solution, and will try it. thanks.