Forum Discussion
different Subtotal at drill up and down level
How can I implement conditional aggregation in Power BI to generate different subtotals based on different drill-down levels within a matrix visual? For Example, suppose I have sales data categorize...
Hi Devender9999,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
BTW, it sounds like a common multiple aggregation level calculation issue, you can also take a look a the following blog to know how to handle this scenario:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng