Adding columns in matrixI

[nithinsakhamuri]

Imagine I have the following table

And I need a matrix like this: I tried adding the allocation and selection columns but no luck.

Thank you very much!

[Anonymous · Accepted solution]

Hi @nithinsakhamuri ,

Please try below steps:

1. below is my test table:
Table:

2. create a measure with below dax formula

Measure =
IF (
    HASONEFILTER ( 'Table'[Calculation] ),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        'Table'[Calculation] = SELECTEDVALUE ( 'Table'[Calculation] )
    ),
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Calculation] IN { "Selection", "Allocation" }
        ),
        [Value]
    ) & "(allocation+selection)"
)

3. add a matrix visual with measure and field

set the column subtotal label:

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

It may be possible.  Share the download link of the PBI file.

[nithinsakhamuri]

Thank you for the response.

Is there any way to add the attribute(allocation+selection) row in the Calculation Column?

[vicky_]

Try go to the settings and "Switch values to rows" under Values > Options.