Forum Discussion
ashi7upt
Helper I
Helper IHow to Dynamically Filter Table B Based on Parameters in Table A Using DAX?
Here’s a reframed version of your question: --- Hi everyone, I have two tables, A and B, and I'm looking to filter table B based on the information in table A. **Table A**: | parameter | value |...
rajendraongole1
Super User
Super UserHi ashi7upt - You can create a new calculated table in Power BI that filters Table B based on the criteria specified in Table A.
FilteredTableB =
FILTER(
TableB,
VAR FilteredA =
CALCULATETABLE(
TableA,
TableA[parameter] = "a" && TableB[a] = TableA[value] ||
TableA[parameter] = "b" && TableB[b] = TableA[value] ||
TableA[parameter] = "c" && TableB[c] = TableA[value]
)
RETURN
COUNTROWS(FilteredA) = 3
)
Hope it works