Groupwise ranking

[Anonymous]

Hello,

I have an issue with Power bi.I have 2 tables which is products and Pivot of products (that menas some columns in products are pivoted by using unpivot column option).I use  the Attribute column in slicer from Pivot of products.Now Iam finding the Top 5(using ranx function) values according to the Attribute slicer by a sales column which is in Products.I got the correct results when I drag the sales and value column(pivot of products) in visual.But when I drag the 'type' column(which has 2 values) it shows the top 5 for every value in 'type' column. But I want top 5 customers by'value' column  wise,even I draged the 'type' column.

Thanks,

Chunduri

[v-qiuyu-msft]

Hi @Anonymous,

Would you please share a pbix file with some dummy data with us? Also please clarify your desired results based on this dummy data. 

Best Regards,
Qiuyun Yu