topic To have parameter in if condition in power BI in DAX Commands and Tips

To have parameter in if condition in power BI

asdf1608 — Thu, 09 Mar 2023 14:14:47 GMT

I have creted a parameter using enter data. Now I need to create a calculated field to include that in filter.

Calculated field is :

[Parameter1] = ""

CONTAINS([parameter1], [column1] )

How do I do this in power BI as in if condition I am not able to call the parameter

Re: To have parameter in if condition in power BI

amitchandak — Thu, 09 Mar 2023 15:20:34 GMT

asdf1608 , You can use in measure not in column

Countx(Table,

[Parameter1] = ""

CONTAINS([parameter1], [column1] ) )

and then you show it in visual at line level

Re: To have parameter in if condition in power BI

asdf1608 — Thu, 09 Mar 2023 15:33:16 GMT

amitchandak This is not working if the column is from different table. Abd this created field will act as filter. Yes/NO filter in tableau. How do I get this in power BI?

Please help in this