Divide using a Explicit Measure |Power Pivot|Excel Forum|My Online Training Hub

Hi All, 

I'm trying to do a simple DIVIDE-operation and can't get it to work. Any suggestions? 

I have one column with different types of costs and income from multiple business units. In another column, I have categorized the different types of income from the mentioned column as "revenue" to be able to summarize all income per business unit and separate it from the costs. I've created an explicit measure for "Revenue" that seems to works and looks like this: 

=CALCULATE(sum(Merge_OutLeft[Cost_Income]),Merge_OutLeft[Typ]="Revenue")

When using it in my formula below I can't get it to work..

=DIVIDE(Merge_OutLeft[Cost_Income],Merge_OutLeft[Revenue])

Any help appreciated.

Regards, 

Jan, Sweden