Enable or Disable a menu view based on a cell value in a row

[sandeepraon]

Hi can anyone suggest how to Enable or Disable a view in menu , based on a cell value in a row.?

currently the restriction seems to be that if i use the show if expression . there is a restriction that i cannot reference column values in the showif expression. any other alternative.

Any help please

@Marc_Dillon  @SkrOYC @Luis_Rodriguez_  @Steve 

[dbaum · Accepted solution]

Indeed, there's not an individual row--and, therefore, no column values from an individual row--that's available for reference in the context of a view's Show if expression. If you have a way to identify the row you want to reference from the view's table, then you can create an expression as you would from anywhere else outside the context of the view. For example:

ISNOTBLANK(SELECT(Table[Column], AND([Email] = USEREMAIL(), [Another Column] = "Some Value")))

Consider instead defining a slice that filters to the rows that you would show and only show the view if that slice is not blank.

[sandeepraon]

Thank you very much dbaum, appreciate your prompt and immense help , it saved me an immense amount of time figuring , out an alternate solution for the same. @dbaum 

it worked like a charm..