Forum Discussion
Helper IIIPower BI Custom Matrix - multiple measure columns(Grand Total , Averages1, Average2)
Hello
can we achieve this format in Matrix , having these Custom Column Measures : GrandTotal, Product Average, Year Average.? can columns organized in this format.?
Rows : Product Type
Column: Date(Year,Quarter, month)
Value: Product Count
Hi refint650
Yes, it is achievable with calculated groups.
please refer to the linked video:https://www.youtube.com/watch?v=z5XtHOzTm_g
Not that with the last versions, you have the calculation groups inside and don't have to use a tabular editor.
https://www.youtube.com/watch?v=vAnb3e1NCjM
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi refint650
The feature is available with power bi pro inside.Anyway, you can also use the dynamic measure method :
https://www.youtube.com/watch?v=DIc-KFPr4LI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
4 Replies
- Ritaf1983
Super User
Hi refint650
Yes, it is achievable with calculated groups.
please refer to the linked video:https://www.youtube.com/watch?v=z5XtHOzTm_g
Not that with the last versions, you have the calculation groups inside and don't have to use a tabular editor.
https://www.youtube.com/watch?v=vAnb3e1NCjM
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- Ritaf1983
Hi refint650
The feature is available with power bi pro inside.Anyway, you can also use the dynamic measure method :
https://www.youtube.com/watch?v=DIc-KFPr4LI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hiļ¼
Thanks for the solution Ritaf1983 provided, and i want to offer some more infoamation for user to refer to.
hello refint650 , you can consider to user a alternative solution, you can consider to switvh the value to row.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
