Forum Discussion
Divide each row value with total row total
Hi, 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 to...
Hi Anonymous , already resolved the issue. Please see below the code. btw, thanks for the reply.
% of total =
VAR fg_volume = CALCULATE([fg count],ALL(table[Receipt Month]), ALL(table[FG date]))
RETURN DIVIDE([fg], fg_volume)
Hi Anonymous ,
What is the [DateFG] in the formula?
As I can see from the screenshot, the row total should be:
CALCULATE (
SUM ( 'table'[FG Count] ),
FILTER (
ALL ( 'table' ),
'table'[year] = SELECTEDVALUE ( 'table'[year] )
&& 'table'[month] = SELECTEDVALUE ( 'table'[month] )
)
)
Best Regards,
Jay
Hi Anonymous , already resolved the issue. Please see below the code. btw, thanks for the reply.
% of total =
VAR fg_volume = CALCULATE([fg count],ALL(table[Receipt Month]), ALL(table[FG date]))
RETURN DIVIDE([fg], fg_volume)