Forum Discussion

Rsanjuan's avatar
Rsanjuan
Advocate III
9 years ago
Solved

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 fo...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    Rsanjuan,

     

    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" )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

Rsanjuan,

 

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" )
)