Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Matrix with Two subdivisions in single columns

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.