Forum Discussion
Max Count Multiplication
I'm reproposing the question and answering some questions in one message. Here's the deal. I have a set of accounts in a table, each row has data on those accounts with historical spend and has been assigned a tier based on their usage and prior spend. I would like to estimate future value with the historical.
These tiers have been given campaigns and are columns in the table. I have summed and averaged out the totals of the campaigns but it's not possible to contact 100% of that file. so, say we have 57,111 people total and we can only contact 4000 people. I want to cap at 4000 and multiply against that campaign's average order size.
the campaign values are wrong, so tiers 1-6 are core clients, and tier 8 is overstocked. as an example, tier 8 should be 4000*423=1,692,000. That is what the campaign value should be, once I have this, I can drill down further by multiplying across contact rates, conversion rates, and dates. I cannot figure out how to get this piece right though.
Here is a link to the data
https://drive.google.com/file/d/1f0qokkiAkoDJ_sFlyhAX5etKMDzMoLyn/view?usp=sharing
Hi Anonymous ,
Has v-janeyg-msft refered the information is not representative but believe I have found a way but cannot confirm the values. Create the measure MAX:
MAX dial counts = if (COUNT(Sheet2[BPN]) <= 4000, COUNT(Sheet2[BPN]), 4000)
Now add the following measure:
TotalCampaing =
SUMX (
SUMMARIZE (
Sheet2,
Sheet2[TIER_DESCRIPTION],
"Maxdialcounts", [MAX dial counts],
"AV18MOS", AVERAGE ( Sheet2[AOV_18MOS] )
),
[Maxdialcounts] * [AV18MOS]
)
Result below and in attach PBIX