Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Jeanxyz ,

     

    What kind of data model do you have and can you provide some test data?

     

    Best Regards,
    Adamk Kong