Matrix with Two subdivisions in single columns

[Anonymous]

Good evening all, I come to you in need of great aid, I need to make a column divided in 2 subdivisions as it is shown on the image: 

I should also add that all the different sub-columns are independent measures from one another. Is there any way to obtain these result.

[Anonymous]

Hi @Anonymous ,

You can load two column to value, and you can receive it

Best Regards,

Xianda Tang

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

[Anonymous]

Greetings @Anonymous , 
I am grateful for your answer, but there are some issues, the different columns are measures using data from several tables for every 2 measures, so the method you propose is unfortunately ineffective for my case. Do you have any other suggestion?

[Anonymous · Accepted solution]

Update: I managed to obtain an acceptable solution, using this line of code:

ACT vs TGT =

CALCULATE (

    SWITCH (

        TRUE (),

        //Excess Actual

        SELECTEDVALUE ( 'ACT vs TGT Structure'[Measure] ) = "Excess"

            && SELECTEDVALUE ( 'ACT vs TGT Structure'[Value] ) = "Actual", FORMAT ( [Excess], "#,0" ),

        //Excess Target

        SELECTEDVALUE ( 'ACT vs TGT Structure'[Measure] ) = "Excess"

            && SELECTEDVALUE ( 'ACT vs TGT Structure'[Value] ) = "Target", FORMAT ( [Excess %], "#%" ),

        //Risk Mitigation Actual

        SELECTEDVALUE ( 'ACT vs TGT Structure'[Measure] ) = "Risk Mitigation"

            && SELECTEDVALUE ( 'ACT vs TGT Structure'[Value] ) = "Actual", FORMAT ( [xxxx], "#0%" ),

        //Risk Mitigation Target

        SELECTEDVALUE ( 'ACT vs TGT Structure'[Measure] ) = "Risk Mitigation"

            && SELECTEDVALUE ( 'ACT vs TGT Structure'[Value] ) = "Target", [xxxxxx],

It can be modified to add more elements to the table, the Measure and Values go in the column section of the matrix visual objects, while the measure goes on the values section.