Forum Discussion
Matrix Help
I have two measures that are working great, see below. The problem is that I am using a matrix to display the data, that part works. What doesn't work is the row total in the matrix. The row total is...
swikritee_p
Resolver II
Resolver IIBetter have a month column and then try like
FY24 Receipts Scenario 1 =
Sumx(values('Merged Balance Data'[Report Month]),
SWITCH(Max('Prod Rev Summary'[Report Month]),
1,'Prod Rev Summary'[FY19 Receipts],
2,'Prod Rev Summary'[FY19 Receipts],
3,'Prod Rev Summary'[FY19 Receipts],
4,'Prod Rev Summary'[FY19 Receipts],
5,'Prod Rev Summary'[FY19 Receipts],
6,'Prod Rev Summary'[FY19 Receipts],
7,'Prod Rev Summary'[FY19 Receipts],
8,'Prod Rev Summary'[FY19 Receipts],
9,'Prod Rev Summary'[FY19 Receipts],
10,'Prod Rev Summary'[FY24 Receipts],
11,'Prod Rev Summary'[FY24 Receipts],
12,'Prod Rev Summary'[FY19 Receipts]
))