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