The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
HI,
I am trying to map origanization hierarchy in matrix and assign distribution of hours worked. But since levels in hierarchy is dynamic, its showig empty leaves in few cases. Please guide as how can i get rid of these empty leaves.
Thanks in Advance.
@ShubhamBarnwal , refer if this can help
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
User | Count |
---|---|
70 | |
64 | |
61 | |
49 | |
28 |
User | Count |
---|---|
117 | |
81 | |
65 | |
55 | |
43 |