cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sure19 Regular Visitor
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
Super User

Re: Calculate from within a column

Highlighted
Community Support Team
Community Support Team

Re: Calculate from within a column

@sure19,

 

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
Super User

Re: Calculate from within a column

Highlighted
Community Support Team
Community Support Team

Re: Calculate from within a column

@sure19,

 

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.