Forum Discussion
Revenue calculation over different projects
Hey,
I am working on a project dashboard.
Therefore i have 7 Projects in my Database (Projectnumber) and I would like to have an intereacitve revenue -depending on my overall filter:
| Projectnumer | Revenue by Day | Revenue Multiple per Day |
| 195 | 30 | 26 |
333 | 25 | 25 |
| 456 | 31 | 90 |
| 123 | 26 | 84 |
Normal revenue formula (for one Project) = Revnue py Day x Revenue Multiple per Day x 360
Is there any one how can help mit with this formula - how to calculate my revenue depending on the Projects which i have selected via filter on my dashboard. Thank you Simon
4 Replies
Hi NomisSimon
You can try the following:
SUMX( TableName, TableName[Revenue by Day] * TableName[Revenue Multiple per Day] * 360 )
Just replace TableName with the name of your data table contianing the project number and revenue columns.Hey Adescript,
thank you very muche, with your quick respond.
I tried it already - i get an value but - the value is not changing if i am changing my project - your formula seems to add up all revenues together - but i need them separate depending on my filter.
Thank you
Hi NomisSimon
It seems to be working for me, unless I have misunderstood your request:
In the example above the Revenue measure is only displaying the revenue for the filtered project numbers.Did you definitely create a measure and not a column?
Hy Adescrit ,
thank you for your respond - i dont get the conecting to my ongoing fylter...
See below that is my measure with i am working with:
Parameter LP = Revenue by Day
Parameter BSS = Revnue Multiple
Parameter = Name of my Tabel
Thank you
