Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |