Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
Solved! Go to Solution.
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.
Hi @vijay_27 ,
Checking out the answer @Daryl-Lynch-Bzy 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
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.
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?
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |