Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi - I have a report from which the user can select the geography that they wish to view data for. They need to be filters as there are too many layers to accomodate slicers on the report pages.
I need to show on a report page what has been selected from the lowest level of geography at any point in time. The heirarchy (in order) is:
Country
Macro Organisation
Decision Making Cluster
Account
Cluster
So if someone selects a / multiple cluster in the 'Cluster' filter, I want the measure to show the cluster name(s). However if they don't select a cluster but have selected an / multiple accounts it should show the account name.
Any idea where to start
Solved! Go to Solution.
HI @lewdow,
You can refer to the following link to know how to handle hierarchy level fields, then you can add if statement with filters to check current hierarchy level and return correspond selected items.
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
HI @lewdow,
You can refer to the following link to know how to handle hierarchy level fields, then you can add if statement with filters to check current hierarchy level and return correspond selected items.
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
Just noticed the Hierarchy slicer/filter released today as a preview version - Feb 2020. Thats exactly what you need.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |