The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a situation where I have a 2-level hierarchy
Channel
Sub Channel
On the report I show
Channel Actual Pct to Plan YoY
Sub-Channel 1
Sales Type 1
Sales Type 2
Sales Type 3
PCT to measure
Sub-Channel 2
Sales Type 1
Sales Type 2
Sales Type 3
Pct to measure
Is there a way to have the Channel (Higher level) to get the grid to look like this. I standard total doesn't make sense since Sales Type 2 Actual is a subset of Sales Type 1 and Sales Type 3 is a different measure all together.
The users want something like this where Channel is the sum of any and all sub channels. Need to do this in a single visual instead of "stacking" (for export)
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample as table format so that I could have a test on it.
Best Regards,
Cherry
Was not what I was looking for. I need "detail" rows at the higher level at the same time as the "Lower" level rows in the hierarchy. Where Parent Metric 1 = Child 1 Metric 1 + Child 2 Metric 1 , etc.
Parent
Metric 1
Metric 2
Metric 3
Child 1
Metric 1
Metric 2
Metric 3
See if this helps:
Matrix Measure Total Triple Threat Rock & Roll
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |