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...
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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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