Power BI Custom Matrix - multiple measure columns(Grand Total , Averages1, Average2)

[refint650]

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

[Ritaf1983 · Accepted solution]

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.

[Anonymous]

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.

[refint650]

@Ritaf1983  so this is doable with regular non premium power bi workspace/desktop  and we dont have tabular studio also.

[Ritaf1983 · Accepted solution]

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.

[Ritaf1983 · Accepted solution]

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.