Data transformation

Hi Anonymous ,

My Sample:

Calculated column:

Convert to Billions = 
IF('Table'[units] = "Billions of U.S. Dollars",'Table'[value],'Table'[value]/1000)

Measure:

Percentage Grouped by banks for Asset = 
VAR _Total =
    CALCULATE (
        SUM ( 'Table'[Convert to Billions] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[banks] ),
            'Table'[series_title] = "Total Assets"
        )
    )
VAR _Value =
    CALCULATE (
        SUM ( 'Table'[Convert to Billions] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[series_title], 'Table'[banks] ),
            'Table'[A/L] = "Asset"
        )
    )
RETURN
    DIVIDE ( _Value, _Total )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.