Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
84 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |