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
Anonymous
Not applicable

Multiply, divide and subtract in same measure

Hi, I'm trying to get this in Powerbi but it's not working. Wondering if anyone could help me please. 

 

 

Cost per Gold pack = (Total Cost - (Silver Packs*£300)) / Gold Packs

 

We spend on marketing £10,000 a week and sell Subscription based Gold Packs. However minority of our customers do end up taking up a Silver pack. The Cost of each silver pack is fixed at £300 each. And there it must taken out of total cost before finding out cost per Gold Pack. 

 

Please let me know if you need more info. 

1 ACCEPTED SOLUTION
quentin_vigne
Solution Sage
Solution Sage

Hi @Anonymous

 

It will probably be something like that : 

 

Cost per Gold Pack = DIVIDE[
SUM(TotalCost) - CALCULATE(SUM(Pack;Pack="Silver Packs)*300 
;
CALCULATE(SUM(Pack;Pack="Gold Packs") )

As I don't have any information on what your table look likes or your column looks like I can't help you more at the moment.

 

If you need more help, can you provide us a sample of your data (dummy data) ?

 

- Quentin

View solution in original post

2 REPLIES 2
trevort
New Member

Hi,

 

First time user of the community, be gentle :).  I'm trying to do the below formula within my measure, any ideas?

=IFERROR((I2-(J2/O2))*P2,0)

Any help welcomed.  

Thank you

quentin_vigne
Solution Sage
Solution Sage

Hi @Anonymous

 

It will probably be something like that : 

 

Cost per Gold Pack = DIVIDE[
SUM(TotalCost) - CALCULATE(SUM(Pack;Pack="Silver Packs)*300 
;
CALCULATE(SUM(Pack;Pack="Gold Packs") )

As I don't have any information on what your table look likes or your column looks like I can't help you more at the moment.

 

If you need more help, can you provide us a sample of your data (dummy data) ?

 

- Quentin

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.