Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
In Power BI Matrix visual i want to get Col1 Total as SUM(Col1) and AVGCol2 as Avergae of the Column total meaning (AVG(Row1:Row3)). How can i achieve this?
Col1 | AVGCol2 | |
Row1 | 10 | 19.72 |
Row2 | 9 | 10.18 |
Row3 | 6 | 31.69 |
TOTAL | 25 | 20.53 |
Solved! Go to Solution.
Hi @TamilselviK
Firstly you need to add a "Row Index" in your data model. We need to add it into Matrix Row Field.
Then add Col1 and Col2 into Matrix Value Field. We can use SUM and AVERAGE Function in Value Field.
My Sample:
SUM and AVERAGE Function in Value Field
Matrix:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TamilselviK
Firstly you need to add a "Row Index" in your data model. We need to add it into Matrix Row Field.
Then add Col1 and Col2 into Matrix Value Field. We can use SUM and AVERAGE Function in Value Field.
My Sample:
SUM and AVERAGE Function in Value Field
Matrix:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
12 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
3 | |
2 | |
2 |