Forum Discussion

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago
Solved

Cascading Tables Improvements?

Good evening, All!   I have a table that has different work types: Epic, Feature, and Backlog. If a user selects an upper level work type, the lower levels (feature and backlog) filters accordingly...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    hnguy71  - You want to "flatten" the parent child hierarchy. You can see a DAX method here or an M method here.

     

    The idea is that your new table will have a column for each of your attributes (Work Type, Epics, etc). 

     

    Cheers!

    Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hnguy71  - You want to "flatten" the parent child hierarchy. You can see a DAX method here or an M method here.

 

The idea is that your new table will have a column for each of your attributes (Work Type, Epics, etc). 

 

Cheers!

Nathan

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

nice! I'll look into it further! Definitely closer to what I'm thinking! Thank you!