Mix fixed and dynamic groups in the same hierarchy

[ssbbb]

I would like to realize a hierarchy on countries with
- Fixed Groups, for example

• Benelux
  • Belgium
  • Netherlands
• Rest of EU
  • France
  • Germany
  • ...

- And in the same hierarchy, also dynamic groups

• Top 10 Rest of the World
  • Country1
  • Country2
• Rest of the Wold
  • all other countries

I was able to find Dax examples for making only a top10, but nothing to make such a hiearchy mix between fixed and dynamic groups... 

[Anonymous · Accepted solution]

Hi, @ssbbb 

Based your information, I create a table:

In Power BI, you can put Country and Fix Group into the matrix.

For dynamic groups, we need to create a calculated column to group them and put them into the matrix view, as shown in the image below:

Dynamic Group = 
IF(
   RANKX(
        ALL('Table'),
        'Table'[Value],
        ,
        DESC,
        Dense
    )<= 6,
    "Top 6 Rest of the World",
    "Rest of the World"
)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ssbbb]

It's great but, how to mix them ? You showed me how to make a fixed and a dynamic, but the question was how to mix them ?