Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a hierarchy table and would like to display total based on what level the slicer is selected.
If all Level 3 (Division) checkboxes selected, display sum of Level 2 (BU) total across all groups
If all Level 2(BU) checkboxes selected, display sum of Level 1(Group) total across all group
If not all Level 3 checkboxes selcted (regardless of BU), display selected Level 3 (Division) total across all BUs
If not all Level 2 checkboxes selcted (regardless of Group), display selected Level 2 (BU)total across all groups.
Below are some examples:
If Audit, SPU, YAD selected, display sum of (Audit, SPU, YAD)
If 7JB and F8C selected, display sum of (7jb and f8c)
If OC9 selected and Audit selected, display sum of (DIM, TIF and Audit)
Maggie I'm not sure if you read my post fully. Look at the example and the slicing selection. I know how to do a basic agg based on slicer selection. This is more complex. There are three totals (Group, BU and Division) I have gotten other feedback and I was able to get part of the solution working. Below are some examples:
1. If Audit, SPU, YAD selected, display sum of (Audit, SPU, YAD) (Division Total)
2. If 7JB and F8C selected, display sum of (7jb and f8c) - BU Total value (Note** This is NOT the sum of all children under that BU)
3. If OC9 selected and Audit selected, display sum of (DIM, TIF and Audit)
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, you might want to check out my Quick Measure, Matrix Measure Total Triple Threat Rock & Roll as it might give you some ideas on how to get what you are looking for:
Greg
Thanks for the feedback. I go tthe total to add up at the Group level havig issues keeping the total at the bottom levels. I've updated the post with example and an updated screenshot of the report.
Any input would be appreciated.
Thanks
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |