Forum Discussion
Jeanxyz
2 years agoPower Participant
matrix table with calculation group
I need to create a matrix table as below:
But in Power BI the year total is blank. I guess by default, Power BI needs to summarize amounts across Row Group (actual, budget, act/budget%) first before it sums up amount across Year Quarter. But I have disabled column subtotals per Row Group.
1 Reply
- AnonymousNot applicable
Hi Jeanxyz ,
What kind of data model do you have and can you provide some test data?
Best Regards,
Adamk Kong