cancel
Showing results for
Did you mean: Frequent Visitor

## Adding two values from a generated matrix table

Hi is there currently a way to just add two values made from a matrix table? Its relatively easy in excel as you just add two rows but struggling to figure this out in PowerBI. For example below: i want to add the Early and Late columms. so the Diamond section will just produce 69.2% (8.55 + 60.65).

Thank you.

1 ACCEPTED SOLUTION  Community Support

Due to I don't know your data model, I build a measure and see the result you want in column subtotal. Measures:

``````Measure =
CALCULATE(SUM('Table'[Value1]),FILTER('Table','Table'[Status]=MAX('Table'[Status])))/100``````
``Measure2 = SUMX(FILTER('Table','Table'[Section] = MAX('Table'[Section])),[Measure])``

Result: Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3  Super User

If they are values in table , create a new column

new Type =
Switch ( True() ,
[Type] in {"Early" ,"Late"} ," Not on Time",
"On Time"
)

and use that. else you can explore segmentation or binning

if they are measures
Not on Time = [Early]+[Late] Frequent Visitor

@amitchandak i have sent you a private message to send the pbix file.  Community Support

Due to I don't know your data model, I build a measure and see the result you want in column subtotal. Measures:

``````Measure =
CALCULATE(SUM('Table'[Value1]),FILTER('Table','Table'[Status]=MAX('Table'[Status])))/100``````
``Measure2 = SUMX(FILTER('Table','Table'[Section] = MAX('Table'[Section])),[Measure])``

Result: Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  