Forum Discussion
SubTotal Adjustment for Matrix
Hi Experts,
Please check and help on this if possible.
I have the below Table display and have the requirement as follows,
1. Do not change anything on Main Total
2. Total of A , B , C from Classification c1 should be the value of c1 ie 16487 and not the default sum A+B+C
H, i, j, K should be 15860 and not 15960.
3. Hide c1,c2, c3
Can you please help on this. PBIX is shared in the below link
https://drive.google.com/file/d/1y5NElxUfhnx4awmd2wXy3dlb8RRrNCxJ/view?usp=sharing
To do this you need to create a Fund Cert2 column
try
19 Replies
Greg_Deckler , hi greg, Thanks for reply. Can u please help how ur sample DAX can be used for my scenario . i tried and was not able to proceed.
Thanks again
do you need it like this?
pls try
I did it only for C3please try full solution
Ahmedx , Thanks a lot for this. The values look good . but it works only for c1, c2 ,c3 while this can be extended to many classification liks c4,e1, etc
Can u please help making it generic? comparing Classification and FundCert values c1=c1, then replace the total value? is this possible? please let me know
To do this you need to create a Fund Cert2 column
try
