Forum Discussion

vijay_27's avatar
vijay_27
Icon for Helper I rankHelper I
4 years ago
Solved

Need top 5 values based on region specific

Hello All, I have Branch, Region, Username, Sales columns in my table.   I have a slicer in report that contains Branch, there is single selection for Branch   Region is top hierarchy over ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi vijay_27 

     

    Here is possible solution.  I created a disconnected table with Branch and Region that does not filter the main fact table.  Then added the "Region Sales Final" calculation.  This allows the selection of Branch and presentation of the Regions Top 5.  I think this partly meets the requirement.  It may not work if you want both Branch and Region on the same page.  If so, it might be useful change to ALL('table regions') or RemoveFilters('table'[regions]) solution for region sales final.

     

    Updated pbix 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi vijay_27 

 

Here is possible solution.  I created a disconnected table with Branch and Region that does not filter the main fact table.  Then added the "Region Sales Final" calculation.  This allows the selection of Branch and presentation of the Regions Top 5.  I think this partly meets the requirement.  It may not work if you want both Branch and Region on the same page.  If so, it might be useful change to ALL('table regions') or RemoveFilters('table'[regions]) solution for region sales final.

 

Updated pbix