Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 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.
Kindest regards
Solved! Go to Solution.
Hi @v-jayw-msft , already resolved the issue. Please see below the code. btw, thanks for the reply.
% of total =
Hi @JWick1969 ,
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 @v-jayw-msft , already resolved the issue. Please see below the code. btw, thanks for the reply.
% of total =
Check out the November 2023 Power BI update to learn about new features.