Forum Discussion
Solved
Display Specific Column Data
I have a matrix that I only want to display the results in column 6 where the result is "0" (zero). Any help would be appreciated.
You can try something like this (if i understand correctly).
NewMeasure = var vResult = [YourMeasure]
Return IF(AND(SELECTEDVALUE(Table[ColumnUsedAsMatrixColumns]) =6, vResult <> 0), BLANK(), vResult)
Pat
You can try something like this (if i understand correctly).
NewMeasure = var vResult = [YourMeasure]
Return IF(AND(SELECTEDVALUE(Table[ColumnUsedAsMatrixColumns]) =6, vResult <> 0), BLANK(), vResult)
Pat