Add custom measure in matrix

[Joshua_]

Hello guys,

I cannot get a solution for this problem.
I need to add a measure to the array, but when I do, the measure is added to the matrix repeatedly.
the measure is not very important, it is a special calculation (product1*0,5+product2*1,3.....).

I was reading and found solutions with the Sumarize function, but I can't apply it correctly in my proyect. could you give me an orientation?

Thank a lot.

[v-yiruan-msft · Accepted solution]

Hi @Joshua_ ,

I created a sample pbix file for you, please check whether that is what you want. It includes two methods in the file, you can find the details in attachment file:

Method 1:

1. Pivot the columns [Products] and [QT]

2. Create a measure to get the value ((product1*0,5+product2*1,3.....)) base on new fields [PRODUCT1],[PRODUCT2] and [PRODUCT3]

Method 2:

1. Create three measures to get QT of these three products QT separately

2. Create a measure to get the value ((product1*0,5+product2*1,3.....)) base on the previous three measures

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[amitchandak]

@Joshua_ , You need a Hybrid table for that. You can refer to the blogs and vote for idea

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

[camargos88]

@Joshua_ ,

Have you tried using the table visual instead of matrix ?