I have a matrix with "fg year and month rows" and "received date" in the column.
the matrix shows the count of fg in each received month. I want to add a % for each value using the fg total row (row level value divided by fg total value.
Example data like below.
Oct 2021 rows and Oct 2021 column the % should be 100%(4622/fg total 6422)
Nov 2021 row and Oct 2021 column the % should be 59.04%(4652/fg total 7883), Nov 2021 column 40.96%(3229/7883)
and so on...
Trying out this code and gives me wrong % value.
Appreciate any help.
Go to Solution.
Hi @v-jayw-msft , already resolved the issue. Please see below the code. btw, thanks for the reply.
% of total =
View solution in original post
Hi @JWick1969 ,
What is the [DateFG] in the formula?
As I can see from the screenshot, the row total should be:
SUM ( 'table'[FG Count] ),
ALL ( 'table' ),
'table'[year] = SELECTEDVALUE ( 'table'[year] )
&& 'table'[month] = SELECTEDVALUE ( 'table'[month] )
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!