Forum Discussion
Anonymous
5 years agoNot applicable
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...
MFelix
5 years agoSuper User
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.