cancel
Showing results for
Search instead for
Did you mean:
sure19 Regular Visitor

## Calculate from within a column

hi,

i have a column called KPI and it has a list of matrics.  example

Total Moves

Essential Moves

etc.

another column has the KPI Value for these metrics

i need to create a new measure called Quality Time with a formula ( total moves - essential moves/total moves)

how can i do this?  Please help.

2 ACCEPTED SOLUTIONS

Accepted Solutions Super User

## Re: Calculate from within a column Community Support Team

## Re: Calculate from within a column

You may refer to the measure below.

```Measure =
VAR t =
CALCULATE ( SUM ( Table1[Value] ), Table1[KPI] = "Total Moves" )
VAR e =
CALCULATE ( SUM ( Table1[Value] ), Table1[KPI] = "Essential Moves" )
RETURN
DIVIDE ( t - e, t )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2 Super User

## Re: Calculate from within a column Community Support Team

## Re: Calculate from within a column

You may refer to the measure below.

```Measure =
VAR t =
CALCULATE ( SUM ( Table1[Value] ), Table1[KPI] = "Total Moves" )
VAR e =
CALCULATE ( SUM ( Table1[Value] ), Table1[KPI] = "Essential Moves" )
RETURN
DIVIDE ( t - e, t )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.