Forum Discussion
Building a matrix with extra columns on certain levels
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!
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
1 Reply
- Ritaf1983
Super User
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