Revenue per volume unit

[gbogue]

I want to calculate the Reveune per Hls (Hectre litres) and I am having problems defining this using measures. The data is in the following format. Thanks for your help

[Ashish_Mathur]

Hi,

Which 2 columns do you want to divide?

[gbogue]

Hello Ashish, 

I want to divide "TotalNetRevenue" by "TotalHls". They are different items under the "attribute" column, with the actual amounts under the "value" column.

Thanks for your help 

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE(SUM(Data[Value]),Data[Attribute]="TotalNetRevenue")/CALCULATE(SUM(Data[Value]),Data[Attribute]="TotalHits")

Hope this helps.