Forum Discussion
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
2 Replies
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
Hi bmarcowka ,
What's your table look like? I did a test. If your table is similar to mine, you can use the function mahoneypat recommends.
Measure = IF(MAX('Sheet2'[C2])=6&&MAX('Sheet2'[value])<>0,BLANK(),MAX('Sheet2'[value]))If not, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
