cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.