Forum Discussion
vijay_27
Helper I
Helper INeed 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 ...
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.
vijay_27Helper I
Helper IHi Anonymous
For example: I have region say Asia, within that I have multiple branch like india, srilanka, china etc...
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..