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 Branch, meaning a region can have multiple branches.
 
Requirement: When I select a branch in slicer, now this branch belongs to particular single region
 
now I need top five value of user based on sales
for that region specific (we got one value of region based on branch selection)

below required imgage shown: 
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 

4 Replies

  • 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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi vijay_27 - I am just checking that I understand the requirement first.  In the example, the branch "1162-N" is selected, but the "Region" should represent all Branches for that Region?

  • vijay_27's avatar
    vijay_27
    Icon for Helper I rankHelper I
    4 years ago
    Hi Anonymous 
    For example: I have region say Asia, within that I have multiple branch like india, srilanka,  china etc... 
    Now suppose I selected any branch say india,  so we get data particular to that branch. And the region is Asia for branch India. 
     
    Now my requirements  is suppose i select branch india in slicer,  then region would be Asia
    Now I need top ten record which are region specific for Asia irrespective of all branches in Asia..
  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi vijay_27 ,

     

    Checking out the answer Anonymous  gave, I think it's a good solution.

     

    If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


    Looking forward to your feedback.


    Best Regards,
    Henry