Forum Discussion
Create a proportion table
Hi,
I have a data table like this :
And I want to create a proportion table like this :
With the total production of each country (every year) and the percentage of drying direct production (drying direct production / total production) for each year
I try lot of methods but I don't find.. if you know a solution I'm interested, thanks !
4 Replies
Anonymous , seem like you are looking for a hybrid table
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebcNot exactly my final goal is to have a graph like this :
With total production and percentage of drying direct production each years for each country (in different colors)
I think the solution is here : https://community.powerbi.com/t5/Desktop/Building-a-Percentage-Table-in-Power-BI/m-p/439195 but I failed to reproduce with my data
Thanks
Hi Anonymous
Thanks for reaching out to us.
How about using this?
Per % = VAR _DryingDirectPerYear = CALCULATE ( SUM ( 'Table'[Valeur] ), FILTER ( ALLEXCEPT ( 'Table', 'Table'[Year] ), 'Table'[Category] = "Drying Direct" ) ) VAR _TotalPerYear = CALCULATE ( SUM ( 'Table'[Valeur] ), ALLEXCEPT ( 'Table', 'Table'[Year] ) ) RETURN IF ( ISFILTERED ( 'Table'[Country] ), BLANK (), _DryingDirectPerYear / _TotalPerYear )Since the Total column is the sum of the each value of the matrix, you need to put the measure in the value of the matrix if you want Percentage to appear in it, which will cause the measure to appear in each column of the matrix.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
