Forum Discussion
Top N value with multiple Columns from different tables.
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
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 DDAli_HYYS , how about merge in power query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi Ali_HYYS,
AFAIK, current power bi does not support creating dynamic calculated column/tables based on filter/slicer. They are work on different data levels and not able to re-calculated/interact with filter/slicer selections on data view.
If you mean to get static top values based on current categories from other tables, it is possible. You can add a variable table into the calculated column to lookup correspond records, then you can apply filters on this variable table to get the specific record as a result display on your calculated column.
Please provide some dummy data if you still confused about the coding formula.
Regards,
Xiaoxin Sheng
