Percentage calculation is not spliting by Month in Matrix table

[Vinothsusai]

Hi,

I am constructing a PL report based on the static template of Finance operations(Ledger transactions).  Here i listed only few records to explain my problem.

Based on the Ids listed, i am trying to calculating total and percentage in DAX formula.

The amount and percentage  should be  calculated by the month split in matrix table Jan,feb.....dec.

Could you please advise.

Id	Description	MainAccount	Date	Amount
40	PARENTS REVENUE	R706000	1/1/2021	2000
41	RETURN CHECK/DD FEES INVOICED	R706150	22/2/2021	2800
42	CREDIT NOTES - PARENTS	R706900	10/3/2021	2800
44	DISCOUNTS	R706910	4/4/2021	2091
46	DISCOUNTS ON SPECIAL OFFERS	R706920	8/5/2021	2800
48	PARENTS REVENUE SUBSIDIES	R741000	13/6/2021	200
50	CATERING FEES	R706050	2/7/2021	2005
52	MEDICAL FEES	R706350	19/8/2021	235
54	TRANSPORTATION REVENUE	R706100	8/5/2021	2010
58	OTHER CHILDCARE REVENUE	R706200	10/3/2021	220
59	Credit Note - Parents Catering	R706903	11/10/2021	90
60	ENRICHMENT INCOME	R708050	10/12/2021	5
61	UNIFORMS/ATTIRE INCOME	R708600	10/3/2021	260
62	REGISTRATION FEES	R708002	11/10/2021	0
REV1	Parents Revenue Total	40+41+42+44+46+48+50+52+54+58+59+60+61+62
68	% Total Parents Revenue	REV1/REV7
72	OPERATING SUBSIDIES	R740000	3/1/2021	2000
73	Operating Subsidies - BaWü	R740100	4/4/2021	2800
74	MFF SUBSIDIES	R740200	8/5/2021	2020
76	BUMI SUBSIDIES	R740250	13/6/2021	225
78	FOOD PROGRAM REVENUE	R740300	2/7/2021	2030
80	TRANSPORTATION REVENUES	R740350	19/8/2021	235
81	PARENTS REVENUE SUBSIDIES - Catering	R741050	8/5/2021	2005
82	PARENTS REVENUE SUBSIDIES - MFF	R741200	10/3/2021	220
83	OTHER OPERATING SUBSIDIES	R742000	11/10/2021	0
84	OPERATING SUBSIDIES ADJUSTMENTS	R742001	10/12/2021	0
86	CONTROL CAF	R742004	10/3/2021	200
87	Other subsidies	R742005	11/10/2021	0
REV2	Subsidies Total	72+73+74+76+78+80+81+82+83+84+86+87
89	% Total Subsidies Revenue	REV2/REV7
REV3	Total Childcare Revenue	REV1+REV2
91	% Total Childcare Revenue	REV3/REV7
93	SPONSOR FEES - CORPORATES	R706001	8/5/2021	2800
94	CREDIT NOTES – CORPORATES	R706901	13/6/2021	2800
95	Key Accounts	R708005	2/7/2021	2000
96	State & Hospital	R708006	19/8/2021	200
97	Small business & Regional Group	R708007	8/5/2021	2000
99	VACANT CRADLES INVOICED	R708100	10/3/2021	210
REV4	Total Corporate Revenue	93+94+95+96+97+99+REV4
100	% Total Corporate Revenue	REV4/REV7
102	SPONSOR FEES - MUNICIPALITIES	R706002	2/7/2021	2800
104	CREDIT NOTES - MUNICIPALITIES	R706902	19/8/2021	3100
106	MUNICIPALITIES BONUS AND PENALTIES	R706102	8/5/2021	2800
REV5	Total Municipalities Revenue	102+104+106
110	% Total Municipalities Revenue	REV5/REV7
116	IC PERSONNEL REINVOICING	R708424	2/7/2021	2042
120	OTHER REVENUE	R708001	19/8/2021	200
REV6	Total Other Revenue	116+120
140	% Total Other Revenue	REV6/REV7
REV7	Total Nurseries Revenue	REV3+REV4+REV5+REV6

Thanks

Vinoth

[Vinothsusai]

Hello,

I have achieved this specific formula on total and percentage row by using Financial reporting matrix tool below.

https://www.profitbase.com/powerbi/

I am facing the problem rendering data is little slow and also i cannot do "show data as point table" on each row.

Expert,

Please advise on this, it can achieve through native power bi matrix table using DAX expressions?

Thanks

Vinoth

[Vinothsusai]

Hello,

Any advise please on the percentage calculation in DAX.

Thanks

Vinoth