Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a matrix with several informations as rows (positions of players, name of players) and I have some data as values. When using the subtotal of rows, the matrix is showing for each position the sum of all players but is it possible to change the sum in order to have the average of each position ?
Thanks in advance for your time and your answer
Solved! Go to Solution.
HI @maxduff59
Do you work with measures or without? In general you should work with measures. But if you do not in this case then please look on the following erxample:
I put fields product and product group and a values into a matrix. you see that the sub totals are a sum by default.
switch to average
result:
but now everything is in average.
second approach if you want to keep the sum below and get the average on top you would create a measure like this.
Measure with sum and average on sub level =
AVERAGEX(
VALUES(Dim_Product[Product Name]),
CALCULATE(SUM(Fact_Sales[Values]))
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
HI @maxduff59
Do you work with measures or without? In general you should work with measures. But if you do not in this case then please look on the following erxample:
I put fields product and product group and a values into a matrix. you see that the sub totals are a sum by default.
switch to average
result:
but now everything is in average.
second approach if you want to keep the sum below and get the average on top you would create a measure like this.
Measure with sum and average on sub level =
AVERAGEX(
VALUES(Dim_Product[Product Name]),
CALCULATE(SUM(Fact_Sales[Values]))
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |