Forum Discussion

Ali_HYYS's avatar
Ali_HYYS
Regular Visitor
6 years ago

Top N value with multiple Columns from different tables.

Hi All, I am starting a dashboard in Power BI in in which i have a requirement of a report with a Top N Customer with Complain number and some other columns from other tables.i have done with a sing...
amitchandak's avatar
amitchandak
Super User
6 years ago

Ali_HYYS , Can you share sample data and sample output in table format? I do not see multiple columns used.

 

For Rank Refer these links

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Ali_HYYS's avatar
Ali_HYYS
Regular Visitor
6 years ago

Current:

Customer Name Premium
AGN 2343
ERP 3455
ERT 76575
WER 45633

Expected:
 Region and Branch against customer coming from other tables.
Customer Name  Premium  Region   Branch
AGN                    2343       Swiss          AA
ERP                     3455      Newzeland  BB
ERT                    76575    Poertland     CC
WER                  45633      Swiss           DD