Forum Discussion
nithinsakhamuri
3 years agoFrequent Visitor
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!
- 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.
nithinsakhamuri
3 years agoFrequent Visitor
Thank you for the response.
Is there any way to add the attribute(allocation+selection) row in the Calculation Column?