Using Field Parameters in Matrix Table

[james_batchelor]

Gurus, 

My situation.  I have a standard matrix table being used to show %growth as a 'heatmap'.  Rows/Columns are dimensions ie  Geo and Product.   All is fine.   I then setup a parameter to allow users to change the columns (Matrix Column Parameter)  and/or Rows (Matrix Row Parameter).   Each would have a list of dimensions..  Geo, Product, Trade Class, etc.  

One cannot have row and column be the same dimension.  So is there a ways to grey out or remove dymanically if already selected in the other dimension?   ie if user picks Geo in rows, Geo should be gone/not selectable in the column paramter.

ideas?

thx

james

[amitchandak · Accepted solution]

@james_batchelor , You can get what is selected using a measure like

What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])

hen you can havve measure

countrows(filter('Axis Slicer2','Axis Slicer2'[Axis Slicer] <> [What is selected]))

Use this as visual level filter , filter for non blank and check