Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gbogue
Frequent Visitor

Revenue per volume unit

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

 

Data.png

1 ACCEPTED SOLUTION

Hi,

Try this measure

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Which 2 columns do you want to divide?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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 

Hi,

Try this measure

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.