Forum Discussion

nithinsakhamuri's avatar
nithinsakhamuri
Frequent Visitor
3 years ago
Solved

Adding columns in matrixI

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's avatar
    Anonymous
    3 years ago

    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.