Replace specific results from matrix to text

[Anonymous]

Hello,

I created matrix table. I would like to replace column: totalhours, rows:  PL, SE, TR from value (which is sum value) into text: N/A text. I was trying to resolve problem by my own, but I could not. Maybe someone got some idea?

Thank you in advance.

Matrix table:

BR 

Lukas

[amitchandak · Accepted solution]

@Anonymous , You can do that but that will make it as text measure

If(Max(Table[Task]) in {"PL", "SE", "TR"} , "#N/A", [TPH]& "")

or

If(Max(Table[Task]) in {"PL", "SE", "TR"} ,blank() , [TPH])