Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In my database, I have a column that has an account hierarchy as below:
1
11
111
112
1111
1112
2
21
211
2111
And so on...
I would like to establish a hierarchy scheme in PowerBI, where I can add all the values from the selected account down.
I do not know yet if I can do this in PowerBI or I'll have to do some mechanism in the database.
Solved! Go to Solution.
Hi @Anonymous,
As the @richbenmintz said, structure of your resource table need to be changed. There are some arctile about parent and child, please review.
Parent-Child Hierarchies
Understanding Functions for Parent-Child Hierarchies in DAX
Best Regards,
Angelia
Hi @Anonymous,
As the @richbenmintz said, structure of your resource table need to be changed. There are some arctile about parent and child, please review.
Parent-Child Hierarchies
Understanding Functions for Parent-Child Hierarchies in DAX
Best Regards,
Angelia
In order to Achieve what you are after you would have to turn your single column into at least two column parent and child. Once that is done you can use the parent child functions in dax to flatten your P/C table into a standard dimension. If you are going to do the work to create the P/C table in the DB you are probably best to do all of the work in the database as you will get better sizing and compression; calculated Columns in Power BI are not compressed.
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |