Building a matrix with extra columns on certain levels

[coffjoh2004]

Hello,

I am building a matrix with 3 row levels: System -> work order -> Item

Each work order has a description that matches with it, and I want it displayed in the same row as the work order when i drill to that level. Descriptions are not applicable to the system level or the item level, so having the "First description" value doesn't make sense. Is there a way to make an extra column appear only for the work order level? I'm just assuming this isn't possible, but curious to hear some feedback.

Thanks!
 

 

[Ritaf1983 · Accepted solution]

Hi @coffjoh2004 
You can add it as a measure with in scope manipulations.
You didn't attach a table to work with so I will show you mine:

description = if(ISINSCOPE('Fact _operaions'[Code]),max('Fact _operaions'[Description]), "Sys.code level")

and with a "closed" hierarchy the user just sees it with some general title:

Please consider Accepting it as the solution to help the other members find it more quickly