cancel
Showing results for
Did you mean:
Highlighted
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)

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.