Forum Discussion
Adding columns in matrixI
- Anonymous3 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.
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.