Replicating Tableau Parameter/Filter in Power BI

Hi DKelso1992 
To achieve the goal, 
after you add field parameters please follow these steps :

1. Add column to the parameters table:

2 . Create a flag measure for the desired filtering :

test =

var

sele_column=

SELECTEDVALUE('Parameter'[selected column])

return

SWITCH( TRUE(),

sele_column="column 1" && max('Table'[Column 1])= 1 ,1,

sele_column="column 2" && max('Table'[Column 2])= 1 ,1,

sele_column="column 3" && max('Table'[Column 3])= 1 ,1,

0)

 

Put the "selected column" on the slicer 

and use a measure that you created as a filter to the roles visual:

result :

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi, DKelso1992 
Maybe you need to filter other visuals by the created flag measure too or to modify the model.

I don't think there is an option to answer this kind of question without access to the report file.
Please share a link to the dummy pbix and I will try to help.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi DKelso1992 

This is not working because all filter manipulations are from parameters.
The parameters are not the same functionality as the dim table with a "normal key".

So as I see the solution here is:

1. To use all parameter manipulations directly from the fact table.

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly