Hi everyone,
I have 2 tables:
First: StructureGroupHierarchy:
| StructureGroupID | StructureGroupName | StructureGroupName | path | Level 1 | Level 2 | Level 3 | Level 4 | Level 5 | Level 6 | Level 7 | Level 8 | Level 9 | StructureGroupRevisionID |
| 53873 | Star | Star | 15|53891|53873 | Marken | Mandant | Star | 53873 | ||||||
| 53874 | Alessi | Alessi | 15|53891|53874 | Marken | Mandant | Alessi | 53874 | ||||||
| 53875 | Mayser | Mayser | 15|53891|53875 | Marken | Mandant | Mayser | 53876 | ||||||
| 53876 | Monari | Monari | 15|53891|53876 | Marken | Mandant | Monari | 53875 | ||||||
| 53877 | Faller Konfitüre | Faller Konfitüre | 15|53891|53877 | Marken | Mandant | Faller Konfitüre | 53877 | ||||||
| 53878 | Churchill´s | Churchill´s | 15|53891|53878 | Marken | Mandant | Churchill´s | 53878 | ||||||
| 53879 | Margot Schmitt | Margot Schmitt | 15|53891|53879 | Marken | Mandant | Margot Schmitt | 53881 | ||||||
| 53880 | Blend | Blend | 15|53891|53880 | Marken | Mandant | Blend | 53879 | ||||||
| 53881 | e+m Holzprodukte | e+m Holzprodukte | 15|53891|53881 | Marken | Mandant | e+m Holzprodukte | 53880 | ||||||
| 53882 | Manas | Manas | 15|53891|53882 | Marken | Mandant | Manas | 53882 | ||||||
| 53883 | Benninger | Benninger | 15|53891|53883 | Marken | Mandant | Benninger | 53883 | ||||||
| 53884 | La Ballerina | La Ballerina | 15|53891|53884 | Marken | Mandant | La Ballerina | 53884 | ||||||
| 53885 | Brandini | Brandini | 15|53891|53885 | Marken | Mandant | Brandini | 53885 | ||||||
| 53886 | Socha | Socha | 15|53891|53886 | Marken | Mandant | Socha | 53886 | ||||||
| 53887 | BEEM | BEEM | 15|53891|53887 | Marken | Mandant | BEEM | 53887 | ||||||
| 53888 | Diemer | Diemer | 15|53891|53888 | Marken | Mandant | Diemer | 53888 | ||||||
| 53889 | Natura Vitalis | Natura Vitalis | 15|53891|53889 | Marken | Mandant | Natura Vitalis | 53889 | ||||||
| 53890 | Sorger | Sorger | 15|53891|53890 | Marken | Mandant | Sorger | 53890 | ||||||
| 53893 | cpm DUE | cpm DUE | 15|53891|53893 | Marken | Mandant | cpm DUE | 53893 | ||||||
| 53894 | onlydesign | onlydesign | 15|53891|53894 | Marken | Mandant | onlydesign | 53894 | ||||||
| 53895 | GD Import | GD Import | 15|53891|53895 | Marken | Mandant | GD Import | 53895 | ||||||
| 53896 | Fuchs und Schmitt | Fuchs und Schmitt | 15|53891|53896 | Marken | Mandant | Fuchs und Schmitt | 53896 | ||||||
| 53897 | Covered | Covered | 15|53891|53897 | Marken | Mandant | Covered | 53897 | ||||||
| 53898 | La Siesta | La Siesta | 15|53891|53898 | Marken | Mandant | La Siesta | 53898 |
Second table: StructureGroupAttribute:
| StructureGroupAttributeID | StructureAttributeID | DataTypeID | StructureGroupRevisionID | IsMandatory | Column |
| 5 | 266 | 1 | 56964 | FALSE | 1 |
| 30 | 266 | 1 | 56810 | FALSE | 1 |
| 75 | 266 | 1 | 56737 | FALSE | 1 |
| 88 | 266 | 1 | 57078 | FALSE | 1 |
| 111 | 266 | 1 | 56675 | FALSE | 1 |
| 112 | 266 | 1 | 57095 | FALSE | 1 |
| 129 | 266 | 1 | 56980 | FALSE | 1 |
| 161 | 266 | 1 | 57229 | FALSE | 1 |
| 242 | 266 | 1 | 56688 | FALSE | 1 |
| 246 | 266 | 1 | 57008 | FALSE | 1 |
| 278 | 266 | 1 | 56975 | FALSE | 1 |
| 322 | 266 | 1 | 56814 | FALSE | 1 |
| 330 | 266 | 1 | 57101 | FALSE | 1 |
| 375 | 266 | 1 | 56790 | FALSE | 1 |
| 377 | 266 | 1 | 56880 | FALSE | 1 |
| 432 | 266 | 1 | 56815 | FALSE | 1 |
| 452 | 266 | 1 | 56895 | FALSE | 1 |
| 456 | 266 | 1 | 57021 | FALSE | 1 |
| 457 | 266 | 1 | 57077 | FALSE | 1 |
| 466 | 266 | 1 | 57267 | FALSE | 1 |
| 502 | 266 | 1 | 56788 | FALSE | 1 |
| 602 | 266 | 1 | 57013 | FALSE | 1 |
| 644 | 266 | 1 | 57020 | FALSE | 1 |
| 663 | 266 | 1 | 57076 | FALSE | 1 |
Relationship column: StructureGroupRevisionID
My expected result:
One visual which shows the StructureGroupHierarchy levels with the AVERAGE count of assigned StructureGroupAttributeIDs for it's children. For example now I have 24.6K Attributes assigned to level_1 in total, but their average would be 3.5K:
Helpful resources
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
