Multiply, divide and subtract in same measure

[Anonymous]

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. 

[trevort]

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 · Accepted solution]

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