Display Specific Column Data

[bmarcowka]

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. 

[Anonymous]

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.

[mahoneypat · Accepted solution]

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