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}))