Create a proportion table

[Anonymous]

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 !

[v-xiaotang]

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.

[amitchandak]

@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/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

[Anonymous]

Hi,

Thanks for youe answers !

[Anonymous]

Not 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