Forum Discussion
Text value in matrix
I have table with information about machine parts. Initial Data looks like: Level 1 Level 2 Name A - aaa A A1 bbb A A2 ccc I want to sea a hierarchy of Level 1 and Level...
Ryo15 , use is in scope
Switch( True() ,
isinscope(Table[Level 2]), Max(Table[Name])
calculate( Max(Table[Name]) , filter(Table, Table[Level 2] = "-"))
)
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/