Forum Discussion
Dynamic MAX for all rows
I have a table that looks like this: H1 H2 H3 H4 H5 # Layers John Smith 1 John Smith Mary Jane 2 John Smith Mary Jane Andrew Johnson 3 John Smith...
DataInsights
Super User
Super UserAnonymous, is there one slicer for each column (H1, H2, etc.), or is there one slicer that filters multiple columns?
DataInsights There is one slicer for each column. Depending on who the user is, they are going to filter on H1, or H2, etc. So if I'm Andrew, for example, I'm gonna use the H3 slicer because my name is in the 3rd hierarchy
- DataInsights
Anonymous, try this measure:
Max Layer H3 = VAR vSelName = SELECTEDVALUE ( Layers[H3] ) VAR vMaxLayer = CALCULATE ( MAX ( Layers[# Layers] ), ALL ( Layers ), Layers[H3] = vSelName ) RETURN vMaxLayerYou can replicate this logic for each column's slicer (H1, H2, etc.).
DataInsights I need the max to be just one column, not 5 different ones 😕