Forum Discussion
Helper IHow to Dynamically Filter Table B Based on Parameters in Table A Using DAX?
Advocate ITo make the filtering dynamic based on the combinations in Table C, you can modify the DAX measure to include the combinations from Table C
FilteredTableB =
VAR DistinctParameters = VALUES(TableA[parameter])
VAR FilteredB =
FILTER(
TableB,
COUNTROWS(
FILTER(
TableA,
SWITCH(
TRUE(),
TableA[parameter] = "a" && TableB[a] = TableA[value] && TableA[parameter] IN VALUES(TableC[parameter]), TRUE,
TableA[parameter] = "b" && TableB[b] = TableA[value] && TableA[parameter] IN VALUES(TableC[parameter]), TRUE,
TableA[parameter] = "c" && TableB[c] = TableA[value] && TableA[parameter] IN VALUES(TableC[parameter]), TRUE,
FALSE
)
)
) = COUNTROWS(DistinctParameters)
)
RETURN
FilteredB
This modification ensures that the filtering conditions are dynamically applied based on the combinations stored in Table C.
If my post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are always appreciated.
Helper IIt does help me resolve the first issue but does not address the second one.