Forum Discussion
Mix fixed and dynamic groups in the same hierarchy
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.
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.
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 ?
