cancel
Showing results for
Search instead for
Did you mean:
Helper IV

## Calculation

This may be a real simple calculation, but I am having trouble gettting it.  Perhaps, because it's a Monday.

What I want to do is calculate the Net Operating Income as a % of Revenue for each month.  I know I want to do Net Operating Income / Revenue, but how do I create the measure with the data set up this way?

Thanks!

1 ACCEPTED SOLUTION
Community Support

You may create a measure as shown below.

```Measure =
DIVIDE (
CALCULATE ( SUM ( Table1[Actual] ), Table1[Metric] = "Net Operating Income" ),
CALCULATE ( SUM ( Table1[Actual] ), Table1[Metric] = "Revenue" )
)
```
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.
4 REPLIES 4
Community Support

You may create a measure as shown below.

```Measure =
DIVIDE (
CALCULATE ( SUM ( Table1[Actual] ), Table1[Metric] = "Net Operating Income" ),
CALCULATE ( SUM ( Table1[Actual] ), Table1[Metric] = "Revenue" )
)
```
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.
Super User II

Hey,

the easiest way to achieve what you want is to pivot your table in Power Query and create two metric colums with the value

And than the result looks like this

From here you can simply your measure, without pivoting your Metric column can can become very difficult to find the proper lines.

Hope this helps

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Frequent Visitor

Do you need the NOI to be in the same column as your monthly income?  Or, could it be in a second column?

Helper IV

@corodyne

It could be in a separate column.

## Helpful resources

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

#### Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors