How can I create a dimension in Power BI that changes relative to selected condition. In this very case if a share of SKU is less then 10% out of total it gets a new name “other”. I belive this can be done in Qlik with aggr to return an array of values from a virtual table. Does Power BI allow such a thing?

table pivot pivot
SKU VALUE SKU VALUE SHARE SKU VALUE SHARE
1 70 1 100 8.6% other 260 22.4%
2 60 2 80 6.9% 4 400 34.5%
3 80 3 80 6.9% 5 500 43.1%
4 400 4 400 34.5%
5 500 5 500 43.1%
1 30
2 20