Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |