Forum Discussion
Matrix Subtotal and GrandTotals are equal
Hi There,
i am new to power bi. I am creating a matrix for Business Central Data . SalesPersonwise Jobs and job's billable and collection result as matrix. I have a filter for Job's createdon date (Year/Qtr Filter)
defDims has Salesperson for the jobs. custLedger has collected amount for the job. Job's total billable is available in jobTaks.
relationships are set correctly.
In matrix , i am not using any measures . only table columns are used
as you can note, the subtotal and Grand totals are equal. anyone kindly guide about Why this strange issue comes in matrix
thank you for any hep
3 Replies
- amitchandak
Super User
dej , As per this, only dimesion is Jobs. Column coming from all other tables(Facts) has to aggregates and you can not use those in group by(Not Summarized), if other facts are used
Thank you amitchandak . When I use the same table structure in Excel , it was working. For BC Data, it is not working. Could you please suggest any way to get the sum
Hi dej
Thanks for the reply from amitchandak .
Could you please provide some sample data and expected results based on the sample data so that we can better help you? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Please remove any sensitive data in advance.
Best Regards,
Yulia Xu
