need help with DAX to hide rows

[jaipal]

Hello professionals,
I need ideas with DAX to hide rows
I have a key measure called "Revenue" and a column column called "Name"

I am showing the in a table with few coulmns and key measures.

Now I need to hide few rows based on below logic

if Revenue <>0 or Name = Unsecured

any ideas would be appriciated. TIA

[jaipal]

@Samarth_18 that works, Thank you

[Samarth_18 · Accepted solution]

Hi @jaipal ,

Create a measure like below and use it as filter on your visual:-

_filter = if( [Revenue] <>0 || Max(table[Name]) = "Unsecured",1,0)

Thanks,

Samarth