Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Max Count Multiplication

I'm hoping this is an easy solution and I'm just missing it. 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 ti...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

Don't know if the MAX value and the AVERAGES are measures what you need to do is a SUMX but based on a temp table using your columns in this case can be something similar to this:

 

Campaing VAlue = SUMX(values(Table[Campaigns]), [DialsCount] * [Average AOV18])

 

If this does not solve your issue can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you very much for helping me with this, I could not figure it out.

    I also tried multiplying the formula to sum aov instead of the column and vice versa witht the column row count. 

     

    Dataset and high-level example

    https://drive.google.com/file/d/1f0qokkiAkoDJ_sFlyhAX5etKMDzMoLyn/view?usp=sharing

     

    The old file I'm trying to replicate in Bi won't carry over the formulas to google drive but here are some screenshots. 

     

    End Goal

     

    Backend data and formulas to get results.

    Link with reference errors (it's because the formulas are referencing a pivot table and that didn't carry over)

    https://drive.google.com/file/d/1Dh260P6Y_lakQEnDayprI779_kFtKcC1/view?usp=sharing

     

    Please let me know if there is anything else I can provide or answer to help work through this.